You execute the following piece of code with appropriate privileges:
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''');
BEGIN
DBMS_ REDACT.ADD_ POLICY(
Object_schema object_name column_name policy_name function_type
Expression
END;
=> 'SCOTT'
=> 'EMP_VW'
=> 'SAL'
=> 'SCOTT_ EMP_VW'
=> DBMS_ REDACT. NONE
=> 'SYS_CONTEXT(''SYS_S ESSION_ ROLES''''MGR'')
= ''FALSE''');
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?
A.Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. B.Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set. C.Data is never redacted for the EMP_VW.SAL column. D.Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set. E.Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.正确答案AC
