Privileges for DBA role

pts.
Tags:
Oracle 9i
In an Oracle 9.2.0.4 database I have a user with DBA as the default role. But I had to grant explicitly via "grant SELECT on ..." to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant separately "select on DBA_USERS and on DBA_ROLE_PRIVS" to this user? This was not needed under Oracle 8.1.7.4. Thanks.

Answer Wiki

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

I have a 9.2.0.1 database. I created a user and granted ‘create session’ to it. I logged in to it and tried a select * from dba_data_files, which failed. I wnet back and granted DBA to this user, logged back on to this user, and did the same select, and it worked. I didn’t have to make any special grants.

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
  • 17051966
    Searching the Oracle MetaLink I found the answer in Note 206795.1. It says that the parameter 07_dictionary_accessibility was set to TRUE in pre-9i and to FALSE in 9i. That explains the behavior change between 8i and 9i.
    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