Home » RDBMS Server » Security » sysdba/resource privs
sysdba/resource privs [message #57875] Mon, 14 July 2003 06:41 Go to next message
Messages: 16
Registered: January 2000
Junior Member
i created a user and gave sysdba privileges and i connected to that user but i am not able to shutdown from that user's session
i gave resource privileges to a user from sys but i am not able to create tablespace in that user's schema
giving error insufficient privileges
why this error happening i already given resource and create tablespace privileges
pls hlp
Re: sysdba/resource privs [message #57878 is a reply to message #57875] Mon, 14 July 2003 16:10 Go to previous message
Messages: 19
Registered: July 2003
Junior Member
In order to shoutdown the database , you have to login as sysdba. For example you create new user as "SCOTT" and give sysdba privilges to "SCOTT" the you have to login to database as "SCOTT AS SYSDBA" in place of only SCOTT.

"RESOURCE" does not have CREATE TABLESPACE privilige, so have to give CREATE TABLESPACE privilige to the user.
Previous Topic: oracle security/reliable
Next Topic: granted the create view priv exclusively
Goto Forum:

Current Time: Thu Sep 21 17:06:18 CDT 2023