author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 30 Sep 2014 19:05:49 +0300 (2014-09-30) | |
changeset 1622 | dec1fd4222e8 |
parent 1621 | a91269720c48 |
child 1623 | 4496f9e49b7b |
oracle.rst | file | annotate | diff | comparison | revisions |
--- a/oracle.rst Mon Sep 29 15:41:15 2014 +0300 +++ b/oracle.rst Tue Sep 30 19:05:49 2014 +0300 @@ -74,6 +74,14 @@ select distinct tablespace_name from user_tables; +List of current user permissions:: + + select * from session_privs; + +List of user permissions to tables:: + + select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%'; + Profiling. ==========