List of user privileges.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 30 Sep 2014 19:30:28 +0300
changeset 1625 0fa6542d8c93
parent 1624 baf11017516f
child 1626 73fa021859e7
List of user privileges.
oracle.rst
--- 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.
 ==========