Monday, May 11, 2015

How to list all tables that a account has privileges in Oracle

In Oracle, to list all tables that a account, say 'TEST', has privileges,

use the following SQL:

SELECT * FROM ALL_TAB_PRIVS WHERE GRANTEE = 'TEST';

No comments:

Post a Comment