author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 30 Sep 2014 19:30:28 +0300 | |
changeset 1625 | 0fa6542d8c93 |
parent 1624 | baf11017516f |
child 1626 | 73fa021859e7 |
oracle.rst | file | annotate | diff | comparison | revisions |
--- a/oracle.rst Tue Sep 30 19:13:46 2014 +0300 +++ b/oracle.rst Tue Sep 30 19:30:28 2014 +0300 @@ -100,6 +100,12 @@ select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%'; +List of user privileges:: + + select * from USER_SYS_PRIVS + select * from USER_TAB_PRIVS + select * from USER_ROLE_PRIVS + Profiling. ==========