tcvduc
tcvduc

Reputation: 189

DBMS_RLS.add_policy: object_name not working

BEGIN
    DBMS_RLS.add_policy(
    object_schema    => 'user_bacsi_01',
    object_name      => 'HOSOBENHNHAN',
    policy_name      => 'VPD_POLICY_DOCTOR_SEE_PATIENT_INFO',
    policy_function  => 'FUNC_VPD_POLICY_DOCTOR_SEE_PATIENT_INFO'
    );
END;
/

Error report -
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_RLS_INT", line 23
ORA-06512: at "SYS.DBMS_RLS", line 54
ORA-06512: at line 2
00942. 00000 -  "table or view does not exist"
*Cause:    
*Action:

Upvotes: 0

Views: 851

Answers (0)

Related Questions