This content has been marked as final. Show 2 replies
The SELECT ANY TABLE privilege means that the user can select from every table in the database.1 person found this helpful
The DBA_TAB_PRIVS view will show any individual SELECT TABLE privileges.
Hope that helps,
Ategrity Solutions Ltd
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.