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

Thread: DDL on the user

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    DDL on the user

    Hi all,

    I have the user named A grant select on his table to user B with "WITH GRANT OPTION" and then user B grant this same table to user C.


    the question is what view can I use so that I can see the "WITH GRANT OPTION" on those object that had them. ALL_TAB_PRIVS only give you the privilege grant from one user to another but not "WITH GRANT OPTION"

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    its the GRANTABLE column, YES means you have the grant option

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    For Tables/Views follow davey23uk's post querying {DBA|ALL}_TAB_PRIVS table.
    For Roles use "ADMIN_OPTION" from {DBA|ALL}_ROLE_PRIVS table.
    "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