2 Replies Latest reply on Jul 31, 2012 12:33 PM by slavonagy

    GRANT EXEMPT ACCESS

    300230
      I was importing data using DATAPUMP for a table say TABLE_A, this table had rows but zero rows imported was what I was getting, upon checking I found that If I issue this command "GRANT EXEMPT ACCESS POLICY TO USER;" it will work, and it did "Great" but now I want to find out what procedures, packages or functions dictate these polices. I tried checking dba_source with text like upper('%dbms_rls.add_policy%') with no rows found. I know that there are some objects that are defining the rules as "GRANT EXEMPT ACCESS POLICY TO USER;" did work.
      How can I find what procedures/Functions or Packages are in place.
      I have no documentation or any help what so ever, but I do have full access to the DEV.
      The version is Oracle 10.1.0.4.0 on a windows OS.

      Thanks to all...

      Habeeb