Oracle 8i/9i Database Access

0 pts.
Tags:
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: February 25, 2005  3:26 PM
UPDATED: February 28, 2005  8:41 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tmutch
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following