oracle.rst
changeset 1622 dec1fd4222e8
parent 1583 46a6bc1e9f2a
child 1623 4496f9e49b7b
--- 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.
 ==========