You execute the following piece of code with appropriate privileges:
BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name
Column_name policy_name function_type expression => 'SCOTT', => 'EMP',
=> 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT
(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; BEGIN
DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name
Policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL',
=> 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT
(''SYS_SESSION_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.DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheM正确答案AC
GR role set. B.DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset. 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. Correct
