| shikhu |
Posted: Sep 27, 2007 06:46:33 AM |
Total Post: 61
Joined: Jul, 2006
|
Hi All,
I want to know the privileges which are given to a particular role.
Thanx.
shikha |
|
|
 Ratnaker |
| Posted: Sep 27, 2007 07:15:47 AM |  |
|
Total Post: 138
Joined: Apr, 2007
|
Hi Shikha,
ROLE_SYS_PRIVS: System privileges granted to roles
• ROLE_TAB_PRIVS: Object privileges granted to roles
• SESSION_ROLES: Roles that the user currently has
enabled
Ratnaker
|
|
|
|
|
| shikhu |
| Posted: Sep 28, 2007 01:59:09 AM | |
|
Total Post: 61
Joined: Jul, 2006
|
Hi KP,
Actually, its not working my role is there in DBA_ROLES I want to know the privileges that are given to that particular role .
Thanx.
|
|
|
|
|
| mani |
| Posted: Sep 29, 2007 09:44:10 PM | |
|
Total Post: 2
Joined: Sep, 2007
|
Use below queries
==================
select * from dba_sys_privs where grantee='DBA_ROLE';
AND
select * from dba_tab_privs where grantee='DBA_ROLE';
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 02:52:24 PM | |
|
Total Post: 416
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
dba_sys_privs,dba_role_privs and OEM has link on user management from where we can obtain details.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
