You might be able to use Oracle’s Virtual Private Database. (fine grain access control)
Once you set that up, I am thinking you could do one of two things:
- Add a column to your table, make it Null. Then set the policy to only select rows where this column is not null.
- or add a few dummy rows to the table with values no other record in the table has. Then set the security policy to select that criteria. Personally I like #1 better.
I have not done this, but I am theorizing based on the Documentation for Oracles VPD. I do not know if this would affect power users such as dba, sysdba, sys etc.
Hope this helps.
On Tue, Jul 25, 2017 at 2:50 PM, prakash.chada email@example.com wrote:
Blocking An Oracle Table from Users Even for Select
Thread created by prakash.chada
I am trying to block a set of tables from some internal users. Mostly PHI data.
Select, Update everything.
The way I did in MS SQL was create a Role with Deny security to these tables. Then assign users to the role.
Any simple way to do it in Oracle?
Appreciate the help.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle Forum notifications altogether.
Toad for Oracle - Discussion Forum
Flag this post as spam/abuse.
Gene L. Bradley Jr.
Office of Information Technology
Jackson State University
1400 J R Lynch Street
P.O. Box 17750
Jackson, MS 39217
*In God we trust; all others bring data. * ~W.E. Deming
This electronic transmission is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone (601) 979-1042. Thank you.