List of current user permissions.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 30 Sep 2014 19:05:49 +0300
changeset 1622 dec1fd4222e8
parent 1621 a91269720c48
child 1623 4496f9e49b7b
List of current user permissions.
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.
 ==========