Question

  Asked: Feb 25 2005   3:26 PM GMT
  Asked by: stevewaltz


Oracle 8i/9i Database Access


Very Large Databases

In the past, many privileges were granted to the PUBLIC pseudo-role in a couple of our databases with a large number of users. We created a role named XPUBLIC and moved all of the privileges to it and are now attempting to limit users to privileges they actually need. Does anyone know of a way to track what privileges are actually used by each user in Oracle 8i/9i?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



You could use views DBA_ROLE_PRIVS and DBA_TAB_PRIVS to identify what roles and object privileges have been granted to a user. HTH.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Database.

Looking for relevant Database Whitepapers? Visit the SearchOracle.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

tmutch  |   Feb 28 2005  8:41AM GMT

You can turn on AUDIT to monitor which users are utilizing which privileges. Be sure to be aware of the size of the AUDIT tablespace as you could fill this up quite quickly depending upon the AUDIT options that you set. I would recommend that you begin by auditing a single privilege to enable you to see what is in your result set.