oracle.rst
changeset 2219 f991bbf12a59
parent 2218 39e18e1912b7
child 2220 f643c573f870
equal deleted inserted replaced
2218:39e18e1912b7 2219:f991bbf12a59
   208 
   208 
   209   select * from USER_SYS_PRIVS
   209   select * from USER_SYS_PRIVS
   210   select * from USER_TAB_PRIVS
   210   select * from USER_TAB_PRIVS
   211   select * from USER_ROLE_PRIVS
   211   select * from USER_ROLE_PRIVS
   212 
   212 
       
   213 List of other users that have access to given user tables::
       
   214 
       
   215   select * from ALL_TAB_PRIVS where GRANTOR = 'ME';
       
   216 
   213 Dump how exactly field stored::
   217 Dump how exactly field stored::
   214 
   218 
   215   select dump(date '2009-08-07') from dual;
   219   select dump(date '2009-08-07') from dual;
   216   select dump(sysdate) from dual;
   220   select dump(sysdate) from dual;
   217 
   221