Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

add READ ANY DICTIONARY privilege

Sven W.Feb 8 2021

Some time ago we got the new READ privilege.
SELECT has the disadvantage to allow LOCKs on the target table. Either via LOCK command or via "select for update...". This can be a potential security issue and therefore the READ privilege was introduced.
Note that there is also the READ ANY TABLE priv.
However it is not possible to give READ ANY DICTIONARY instead of SELECT ANY DICTIONARY.
Suggestion is to implement this.

Comments
Post Details
Added on Feb 8 2021
0 comments
2,250 views