A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted?
A.
SYS sessions, regardless of the roles that are set in the session
B.
SYSTEM sessions, regardless of the roles that are set in the session
C.
SCOTT sessions, only if the MGR role is set in the session
D.
SCOTT sessions, only if the MGR role is granted to SCOTT
E.
SCOTT sessions, because he is the owner of the table
F.
SYSTEM session, only if the MGR role is set in the session
Explanation:
Both users SYS and SYSTEM automatically have the EXEMPT REDACTION POLICY system privilege.
(SYSTEM has the EXP_FULL_DATABASE role, which includes the EXEMPT REDACTION POLICY system
privilege.) This means that the SYS and SYSTEM users can always bypass any existing Oracle Data Redaction
policies, and will always be able to view data from tables (or views) that have Data Redaction policies defined
on them