-
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
-
dba_tab_privs should do the job.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|