InterviewSolution
| 1. |
What Is Needed To Create A Vpd? |
|
Answer» To create a VPD, we have to create what is known as an application context and then implement fine grained access control to enforce the row-level SECURITY for database tables and views. The application context helps US create security policies that draw upon certain aspects of a user's session information. For example when an user LOGS into the database, the user ID identifies the user, and BASED on that piece of information, the application's security POLICY sets limits on what the user can do within the database. VPD is simple an implementation of the application context with fine-grained access control. To create a VPD, we have to create what is known as an application context and then implement fine grained access control to enforce the row-level security for database tables and views. The application context helps us create security policies that draw upon certain aspects of a user's session information. For example when an user logs into the database, the user ID identifies the user, and based on that piece of information, the application's security policy sets limits on what the user can do within the database. VPD is simple an implementation of the application context with fine-grained access control. |
|