author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Thu, 25 Jan 2018 14:51:13 +0200 | |
changeset 2219 | f991bbf12a59 |
parent 2218 | 39e18e1912b7 |
child 2220 | f643c573f870 |
oracle.rst | file | annotate | diff | comparison | revisions |
--- 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;