OraFAQ Forum: Server Administration » can user have right on two tablespace ?

Home » RDBMS Server » Server Administration » can user have right on two tablespace ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can user have right on two tablespace ? [message #113507]

Mon, 04 April 2005 05:42

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi,

My question is.... can user have right on two tablespace ?

and if ANSWER IS YES

THEN PLEASE SEND ME THE QUERY TO ASSIGN PRIVILAGE TO USER ON TWO TABLESPACE?

sunil

Report message to a moderator

Re: can user have right on two tablespace ? [message #113510 is a reply to message #113507]

Mon, 04 April 2005 05:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

for specific tablespaces you need to assign the quota.

sql>alter user username quota unlimited [or yourquota] tablespace tablespacename;

-- for all tablespaces grant the user with RESOURCE ROLE
sql> grant resource to username;

Report message to a moderator

Previous Topic:	What information is stored in the redo change vectors exactly
Next Topic:	can we view the data present in the Dump file.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:31:46 CDT 2024