List of other users that have access to given user tables.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 25 Jan 2018 14:51:13 +0200
changeset 2219 f991bbf12a59
parent 2218 39e18e1912b7
child 2220 f643c573f870
List of other users that have access to given user tables.
oracle.rst
--- a/oracle.rst	Wed Jan 24 16:42:34 2018 +0200
+++ b/oracle.rst	Thu Jan 25 14:51:13 2018 +0200
@@ -210,6 +210,10 @@
   select * from USER_TAB_PRIVS
   select * from USER_ROLE_PRIVS
 
+List of other users that have access to given user tables::
+
+  select * from ALL_TAB_PRIVS where GRANTOR = 'ME';
+
 Dump how exactly field stored::
 
   select dump(date '2009-08-07') from dual;