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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,536 views