How to find all tables that a user can SELECT from in oracle database?
Anonymous Answered question 04/10/2022
Below is the sample script to find all tables that a user can select in oracle database:
1 | select * from dba_tab_privs where GRANTEE = 'Mereba' and privilege = 'SELECT' ; |
Where ‘Mereba’ is the oracle user.
meda Changed status to publish 04/10/2022