Identify the correct statements about the working of Fine Grained Access Control.
A table can have only one security policy.
Different policies can be used to protect the
SELECT
,INSERT
,UPDATE
, andDELETE
statements on a table, but not one.The policy function returns the predicate information as
WHERE
<Column>
=
<Value>
.Once associated, the FGAC policy cannot be revoked from the table.
A security policy can be associated to a group of objects by the DBA. State whether this is true or false.
True
False
Choose the correct statement about
DBMS_RLS
.DBMS_RLS
is used only for row-level security policies.The package is owned by
SYS
.It can create / drop / refresh policies and create/drop policy groups.
Using
DBMS_RLS
to set the policy degrades the application performance.
Identify the correct statements about the context of an application.
A user who holds the
CREATE
CONTEXT
privilege can create a context.It is owned by the
SYS
user.A user can check the context metadata in...
You're reading from Advanced Oracle PL/SQL Developer's Guide (Second Edition) - Second Edition
The rest of the page is locked
You have been reading a chapter from
Advanced Oracle PL/SQL Developer's Guide (Second Edition) - Second EditionPublished in: Feb 2016Publisher: ISBN-13: 9781785284809
© 2016 Packt Publishing Limited All Rights Reserved