A redaction policy was added to the SAL column of the SCOTT.EMP table:
BEGIN
DBMS_REDACT.ADD_POLICY(
Object_schema object_name column_name policy_name function_type
Expression
END;
=> 'SCOTT'
=> 'EMP'
=> 'SAL'
=> 'SCOTT_EMP'
=> DBMS_REDACT.FULL
=> 'SYS_CONTEXT(''SYS_SESSION_ROLES''''MGR'')
= ''FALSE''');
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正确答案ABC
