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.