izeye
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment