A redaction policy was added to the SAL column of t he SCOTT.EMP
Table:
BEGIN .DBMS_REDACT.ADD_POLICY(
Object_schema
=> 'SCOTT',
Object_name
=> 'EMP',
Column_name
=> 'SAL',
Policy_name
=> 'SCOTT_EMP',
Function_type
=> DBMS_REDACT.FULL,
Expression
=>
'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'')
= ''FALSE'''); END;
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 t he session B.SYSTEM sessions, regardless of the roles that are set in t he session C.SCOTT sessions, only if t he MGR role is set in t he session D.SCOTT sessions, only if t he MGR role is granted to SCOTT E.SCOTT sessions, because he is the owner of the table F.SYSTEM session, only if t he MGR role is set in t he session正确答案ABC