Looking for Data Dictionary View(s)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Looking for Data Dictionary View(s)

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    Looking for Data Dictionary View(s)

    Hi Everyone,

    Could somone please tell me which Database Dictionary View(s) contain the information on which user has access rights to certain database objects?

    Say I have a certain table or view and I wanted to know which users have been granted select rights on it, or which users have execute rights on a certain function or procedure.

    Thanks
    Peer

  2. #2
    Join Date
    Apr 2006
    Posts
    50
    dba_tab_privs should do the job.

  3. #3
    Join Date
    Nov 2001
    Posts
    118
    Thanks Graham, that's a great help, just what I was looking for.
    Bye
    Peer

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