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?
收藏
