TruTek can implement a Virtual Private Database for you in order to grant different people different access to different rows of the same table. This is critical for companies that are hosting databases for their applications. Combine all the databases into one instance and save resources. TruTek Virtual Private Database (VPD) Services 
- Define Application Partitioning Policy
- Configure the Virtual Private Database
- Configure Context Pooling
- Install and Configure Advanced Security Option
The Virtual Private Database allows you to easily: - Associate security policies (implemented by functions) with tables or views
- Server automatically enforces security policies (no matter how data is accessed)
- Application context allows flexible access control definition
- Eliminates the need of using many views to implement security
| | | SELECT * FROM orders WHERE cust_no = (SELECT cust_num FROM customers WHERE cust_name = USERENV('user'))
|
|
|
|