How to find all tables that a user can SELECT from

Question

301 views04/10/2022Oracle Database

0

Ezana886 03/10/2022 0 Comments

How to find all tables that a user can SELECT from in oracle database?

Write your answer.

score 0 · Answer 1 · 2022-10-04T14:10:30+00:00

Below is the sample script to find all tables that a user can select in oracle database:

select * from dba_tab_privs where GRANTEE ='Mereba' and privilege = 'SELECT';

Where ‘Mereba’ is the oracle user.