| Oracle privileges [message #55293] |
Thu, 16 January 2003 04:44  |
Ila
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
what role would you assign to project manager who needs to withdraw and add users to the project?
How do you view who has what prilvileges on a database project, what command would you use to view them?
|
|
|
|
| Re: Oracle privileges [message #55361 is a reply to message #55293] |
Mon, 20 January 2003 11:57  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Question#1:
Grant the manager: CREATE USER, ALTER USER and DROP USER system privileges;
Question#2:
Query these views:
SQL> desc dba_role_privs
Name Null? Type
----------------------------------------- -------- -------------------
GRANTEE VARCHAR2(30)
GRANTED_ROLE NOT NULL VARCHAR2(30)
ADMIN_OPTION VARCHAR2(3)
DEFAULT_ROLE VARCHAR2(3)
SQL> desc dba_sys_privs
Name Null? Type
----------------------------------------- -------- -------------------
GRANTEE NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
ADMIN_OPTION VARCHAR2(3)
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
