Row level security
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Row level security

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    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.

  2. #2
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    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.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Schizophrenia and you.
    I remember when this place was cool.

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    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
  •  


Click Here to Expand Forum to Full Width