# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1516884673 -7200
# Node ID f991bbf12a59f6593037665b0b3ade32eae8f4d8
# Parent  39e18e1912b7cce009c9a353d8460dac1af7d22a
List of other users that have access to given user tables.

diff -r 39e18e1912b7 -r f991bbf12a59 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;