|
- A virtual database allows or prevents data access at the row or column level.
- Row and column access can be implemented by using the VIEW database object.
- VPDs are also referred to as row-level security (RLS) or fine-grained access.
- One of the uses of a view object is to limit what users can see and do with the existing data in a table
- A trigger is a stroed PL/SQL procedure that fires automatically when a specific event occurs.
- Application context is functionality specific to Oracle that allows the setting of database application variable that can be retrieved by database sessions.
- The sys_context fuction is used to get values for all predefined attributes in Oracle.
- In Oracle, you can set your own application context using the procedure supplied in the Oracle PL/SQL package called DBMS_SESSION.
- Use the set_context procedure within DBMS_SESSION to set a user's defined application context.
- Use the Oracle supplied package DBMS_RLS to add the VPD policy used to enforce row- and column-level security.
- Oracle data dictionary view enables you to see every thing created and stored in the database.
- Oracle policy manager is a graphical tool used to administer VPD policies.
- Oracle has the capability to restrict updates or insert on columns, using GRANT UPDATE and INSERT (column).
|
