This discussion is archived
2 Replies Latest reply: Nov 15, 2012 9:11 PM by KrishnaAgnihotri RSS

Select any table privilege

KrishnaAgnihotri Explorer
Currently Being Moderated
Hi

I want to list down all the tables name on which xx user has select any table privilage. kindly inform me on which view i can query. I am using 11g DB

Thanks
Krishna
  • 1. Re: Select any table privilege
    IBarr Explorer
    Currently Being Moderated
    The SELECT ANY TABLE privilege means that the user can select from every table in the database.

    The DBA_TAB_PRIVS view will show any individual SELECT TABLE privileges.

    Hope that helps,

    Iain Barr
    Ategrity Solutions Ltd
  • 2. Re: Select any table privilege
    KrishnaAgnihotri Explorer
    Currently Being Moderated
    Hi All,

    I have one user XX (Customs), which has privilage of "Select any table". In my instance since very long back this custom user is used to give select grant to other users/objects on various tables/views. Now if now i revoke "Select any table" grant from XX user "N" number of views become invalied (as while creating custome tables/view XX user is used). and to make valid i need to give grant on individual tables.

    My question is can i join some view/queries to make list of all such tables/view where xx custom user is used for 'Select any table" privilage.

    Thanks
    Krishna

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points