Hidden rows after import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Hidden rows after import

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question Hidden rows after import

    I did a full import of a database with SYSTEM which has 'exempt access policy' privs.
    All the tables and rows were imported successfully. However, the owner (TTBG) of table TTBG.TBG_CRIM cannot see the data. Only SYSTEM can see the data of this table. There is a policy on this table. All the policies were also imported. Why cant owner of this table TTBG not see the data in this table ?

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Two privileges are needed... EXECUTE privilege on the DBMS_RLS package AND either EXPORT_FULL_DATABASE role enabled or EXEMPT ACCESS POLICY granted .

    Was the export done by DBA?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    Quote Originally Posted by PAVB View Post
    Two privileges are needed... EXECUTE privilege on the DBMS_RLS package AND either EXPORT_FULL_DATABASE role enabled or EXEMPT ACCESS POLICY granted .

    Was the export done by DBA?

    Yes the export was done by user 'ADMEXPL' which has DBA, EXEMPT ACCESS POLICY and EXPORT_FULL_DATABASE privs.

    What do I need to do now ? Re-export ? then GRANT execute ON dbms_rls TO ADMEXPL ?;

    Please provide the steps required. Thank you.

  4. #4
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    can you post the export script here?
    Looking for the greatest evil in the world? Look in the mirror.

  5. #5
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    exp admexpl/pr0foru@%%i full=y STATISTICS=NONE buffer=20000000 CONSISTENT=Y direct=n File=E:\ORACLE\EXPORT\DUMP\EXP_%%i_%%j.dmp log=E:\ORACLE\EXPORT\LOGS\EXP_%%i_%%j.log grants=y rows=y )

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