diff -r a91269720c48 -r dec1fd4222e8 oracle.rst --- 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. ==========