| Soumya |
Posted: Nov 07, 2006 06:01:39 AM |
Total Post: 57
Joined: Mar, 2006
|
Hi ,
Is there any query to check all user role & privilege granted to user/role.
please let me know .
|
|
|
 ankur |
| Posted: Nov 07, 2006 07:47:10 AM |  |
|
Total Post: 59
Joined: Nov, 2006
|
u can see roles from here ....
i dont know for object privilages.......
select * from dba_role_privs
|
|
|
|
|
| ankur |
| Posted: Nov 07, 2006 07:48:59 AM | |
|
Total Post: 59
Joined: Nov, 2006
|
other one to check obj privs
select * from dba_tab_privs
|
|
|
|
|
| Soumya |
| Posted: Nov 07, 2006 07:50:33 AM | |
|
Total Post: 57
Joined: Mar, 2006
|
thx,
But I want to know all specific role/privilige granted to a user .
Is there any query ?
|
|
|
|
|
| ankur |
| Posted: Nov 07, 2006 08:01:32 AM | |
|
Total Post: 59
Joined: Nov, 2006
|
put a where clause in 1st statement or wanna see both then join them n give the name of user in where
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
