Skip to Main Content

Oracle Database Discussions

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!

How to prevent user from accessing all_* views for example all_views in oracle database 12.2

knowledgespringSep 24 2019 — edited Sep 27 2019

We want to restrict a user to read/write only his objects and not anything else. we tried to restrict a user with security realm , FGA (there seems to be no SELECT TRIGGER) but seems to be not possible.. the requirement is we want to prevent user from reading all_* view for example all_views.  Can someone please suggest is there anyway to do this. . just not all_views but also sys.all_views (with prefix or without prefix -sys). thanks.

Comments
Post Details
Added on Sep 24 2019
13 comments
1,582 views