Grants not Exported
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Grants not Exported

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    41

    Angry

    I performed export/import from 7.3.3 to 8.i.7.0 database.
    It went good but feel that ther were some grants on certain on dba_tables and role_privs table which are not in effect in new database 8i7. Due to which when than the user who is suppose to run a sql select on the dba_role_privs table is not able to do that in oracle 8i7 while same user can select on dba...view on 7.3.3 database.
    Best Regards,
    Harsh Shah

  2. #2
    Join Date
    Feb 2001
    Posts
    66
    Check the imp log file to see the specific error message

  3. #3
    Join Date
    Feb 2001
    Posts
    41
    never mind I have found the way to work around the problem
    it's actually a back point of oracle sys user cannot export his own given grants for his own objects.
    Best Regards,
    Harsh Shah

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