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
‹
›
Home
View web version
No comments:
Post a Comment