how to hide data of column on table in Oracle database 9.2.0.6?
I have in 11g r2 this : BEGIN
DBMS_RLS.ADD_POLICY (object_schema => 'ADM_JBENITE',
object_name => 'emp',
policy_name => 'sp_job',
function_schema => 'ADM_JBENITE',
policy_function => 'pf_job',
sec_relevant_cols => 'sal,comm',
sec_relevant_cols_opt => DBMS_RLS.ALL_ROWS);
END;
This show all rows but sal and comm column show null where the condition is true.
How to implement this on 9.2 ?
DBMS_RLS.ADD_POLICY (object_schema => 'ADM_JBENITE',
object_name => 'emp',
policy_name => 'sp_job',
function_schema => 'ADM_JBENITE',
policy_function => 'pf_job',
sec_relevant_cols => 'sal,comm',
sec_relevant_cols_opt => DBMS_RLS.ALL_ROWS);
END;
This show all rows but sal and comm column show null where the condition is true.
How to implement this on 9.2 ?
0