DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to check granted privs on views to user

  1. #1
    Join Date
    Jan 2013
    Posts
    3

    How to check granted privs on views to user

    Hi,

    I have granted select privilege on view to user at that time it got completed successful. But customer is asking he dont have access on that view. Is there any chance to check privileges on views to user in oracle 11g.


    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    User_tab_privs

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You might also check dba_Dependencies for what grants are needed for a particular view.

  4. #4
    Join Date
    Jan 2013
    Posts
    3
    Hi gandolf989

    I have already granted select privs on view but i need to check it now but am not able to check which privs i have granted to user on particular view.

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