InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A Virtual Private Database? |
|
Answer» Oracle 8i introduced the NOTION of a Virtual Private Database (VPD). A VPD offers Fine-Grained Access Control (FGAC) for secure separation of data. This ENSURES that users only have access to data that pertains to them. Using this option, one COULD even store multiple companies' data within the same schema, WITHOUT them knowing about it. VPD configuration is done via the DBMS_RLS (Row Level SECURITY) package. Select from SYS.V$VPD_POLICY to see existing VPD configuration. Oracle 8i introduced the notion of a Virtual Private Database (VPD). A VPD offers Fine-Grained Access Control (FGAC) for secure separation of data. This ensures that users only have access to data that pertains to them. Using this option, one could even store multiple companies' data within the same schema, without them knowing about it. VPD configuration is done via the DBMS_RLS (Row Level Security) package. Select from SYS.V$VPD_POLICY to see existing VPD configuration. |
|