Database Security Products (MOSC)

MOSC Banner

how to hide data of column on table in Oracle database 9.2.0.6?

edited Nov 4, 2013 3:41AM in Database Security Products (MOSC) 4 commentsAnswered ✓
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 ? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center