Q
Manage Learn to apply best practices and optimize your operations.

How to apply row level security in Oracle

I am using Oracle 9i Release 1 and I want to apply row level security on my table. What is the procedure? Utilizing...

the Virtual Private Database (VPD) functionality (available in Oracle9i Enterprise Edition) is an excellent way to add row-level security to tables in the Oracle database. This functionality works by associating a WHERE clause to each table and, through the query rewrite engine, this WHERE clause is added to each SQL statement issued against the table. By placing the security mechanism at the table level, there is no way to circumvent it by using an alternate tool (like SQL*Plus) to query the database.

Additional functionality can be found in the Oracle Label Security option which utilizes the VPD toolkit to provide a higher level of security that has been verified and tested against U.S. and other government standards for data security.
 

Dig Deeper on Oracle database security

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close