| sysdba/resource privs [message #57875] |
Mon, 14 July 2003 06:41  |
Sunitha
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  |
Navtej
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.
CREATE TABLESPACE.
"RESOURCE" does not have CREATE TABLESPACE privilige, so have to give CREATE TABLESPACE privilige to the user.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
