2 Replies Latest reply on Nov 16, 2012 5:11 AM by KrishnaAgnihotri

    Select any table privilege


      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

        • 1. Re: Select any table privilege
          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
          1 person found this helpful
          • 2. Re: Select any table privilege
            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.