Home » RDBMS Server » Security » check permissions or privileges given to user
check permissions or privileges given to user [message #195363] Thu, 28 September 2006 04:28 Go to next message
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 #195554 is a reply to message #195363] Fri, 29 September 2006 07:55 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Login to the user and run:

SELECT * FROM session_privs;

SELECT * FROM session_roles;
Re: check permissions or privileges given to user [message #196987 is a reply to message #195554] Mon, 09 October 2006 08:12 Go to previous message
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.
Previous Topic: Security Patches for 9i.2.0.5.0
Next Topic: getting ora 1034 and ora 27101
Goto Forum:
  


Current Time: Wed Dec 11 20:08:12 CST 2024