Users accessing multiple schemas
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Users accessing multiple schemas

  1. #1
    Join Date
    Apr 2007
    Posts
    24

    Users accessing multiple schemas

    We have data mart and data warehouse under one instance. Some users user DM (DM has multiple schemas) and some users use DW (one schema) and some users access objects from both (DW and DM). Can someone please let me know the best way to find what objects/schemas each user has access to or is allowed to (10g database)? I have 171 users defined.

    Thanks in advance!

    Vpons

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,476

    Talking Dba_tab_privs

    Try:

    {ALL|DBA}_TAB_PRIVS
    DBA_ROLE_PRIVS

    Which you could found out yourself if you have read the fine Oracle Database Reference Manual.
    Last edited by LKBrwn_DBA; 11-10-2008 at 12:23 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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