-
Row level security
Hi
we are trying to implement Row level security. I am at the stage to register the Policy function with the database and I am getting this error
SQL> show errors package body vpd_policy
No errors.
SQL>
SQL> begin
2 dbms_rls.add_policy(
3 object_schema => 'VPD',
4 object_name => 'TRANSACTIONS',
5 policy_name => 'VPD_TEST_POLICY',
6 function_schema => 'VPD',
7 policy_function => 'VPD_POLICY.VPD_PREDICATE',
8 statement_types => 'select, insert, update, delete',
9 update_check => TRUE,
10 enable => TRUE,
11 static_policy => FALSE);
12 end;
13 /
dbms_rls.add_policy(
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'ADD_POLICY'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Can someone make a suggestion please?
thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
I figure it out and fixed the problem
Thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
I remember when this place was cool.
-
Thanks Mr.Hanky and who/whatever Schizophrenia is.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|