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!

How to restrict DB user to view table data if he has SELECT permissionle

user11141303Nov 1 2013 — edited Dec 2 2013

An Oracle DB user has SELECT permission on all the tables of a DB schema. Can i restrict the user to view the table data.The user should be able to select the table but should not be able to see the data. This specific requirement is required for user who reviews DB design and generates ALTER script for DB using Oracle Data Modeler 3.3 where he can just see the table design and can compare it with ERD Can i achieve it using FGAC or RLS?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2013

Added on Nov 1 2013

#database-security, #database-security-general, #security, #user

5 comments

3,293 views