Home » RDBMS Server » Server Administration » unlimited tablespace
unlimited tablespace [message #161300] Fri, 03 March 2006 02:54 Go to next message
oracram
Messages: 17
Registered: February 2006
Junior Member
hi all,

does providing the unilimited tablespace privilege to a user, enables the unlimited quota on system tablespace?
or only the non-system tablespace?

with regards

arc

Report message to a moderator

Re: unlimited tablespace [message #161352 is a reply to message #161300] Fri, 03 March 2006 07:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Had you granted RESOURCE role to the user, it may endup troublesome. If resource is been granted, the user has permission to write to any tablespace (including the system).
If the user USER1 has only default tablespace TBS1 assigned , then you need allocate quota for USER1 on that tablespace TBS1

Report message to a moderator

Re: unlimited tablespace [message #161427 is a reply to message #161352] Sat, 04 March 2006 00:40 Go to previous message
oracram
Messages: 17
Registered: February 2006
Junior Member
tx mahesh

Report message to a moderator

Previous Topic: Oracle 9i installation
Next Topic: Regarding Datafile
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:28:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.