check permissions or privileges given to user [message #195363] |
Thu, 28 September 2006 04:28  |
oracle_coorgi
Messages: 188 Registered: September 2006 Location: INDIA-karnataka
|
Senior Member |
|
|
hi
1.how do i find or know what privileges or permission i have given to user test1
2.how do i find or know what role i have given to user test1
which is the dict (select query helpful)
thanxs
|
|
|
|
Re: check permissions or privileges given to user [message #196987 is a reply to message #195554] |
Mon, 09 October 2006 08:12  |
mediapirate
Messages: 1 Registered: October 2006 Location: Arlington, VA
|
Junior Member |
|
|
Does anyone have a script which will audit all users and the roles they're assigned per object? We have a audit request to present all the users, permission level to each T.S. I've searched and searched but I've only found a way to pull the User_Name, Group and Default Group.
|
|
|