Oracle 8i/9i Database Access
Home > IT Answers > Database > Oracle 8i/9i Database Access
stevewaltz
0 pts.
0
Q:
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?
ASKED: Feb 25 2005  3:26 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
rpower3
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Feb 26 2005  5:41 PM GMT by rpower3   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

tmutch   0 pts.  |   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.

 
0