Code Listing 1: Setting user labels

SQL> EXEC sa_user_admin.set_user_labels -

        ( policy_name     => 'DOC_POLICY' -
        , user_name       => 'MGR' -
        , max_read_label  => 'INTERNAL:HR,FIN:ALL' -
        , max_write_label => 'INTERNAL:HR,FIN:ALL' -
        , min_write_label => 'PUBLIC' -

        , def_label       => 'INTERNAL:HR,FIN:ALL' -
        , row_label       => 'PUBLIC');

SQL> EXEC sa_user_admin.set_user_labels -
        ( policy_name     => 'DOC_POLICY' -
        , user_name       => 'HR_EMP' -

        , max_read_label  => 'INTERNAL:HR:WEST' -
        , max_write_label => 'INTERNAL:HR:WEST' -
        , min_write_label => 'PUBLIC' -
        , def_label       => 'INTERNAL:HR:WEST' -
        , row_label       => 'PUBLIC');



SQL> EXEC sa_user_admin.set_user_labels -
        ( policy_name     => 'DOC_POLICY' -
        , user_name       => 'EMP' -
        , max_read_label  => 'PUBLIC' -
        , max_write_label => 'PUBLIC' -
        , min_write_label => 'PUBLIC' -
        , def_label       => 'PUBLIC' -
        , row_label       => 'PUBLIC');


E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy