oracle.rst
changeset 1625 0fa6542d8c93
parent 1624 baf11017516f
child 1905 fba288d59662
equal deleted inserted replaced
1624:baf11017516f 1625:0fa6542d8c93
    98 
    98 
    99 List of user permissions to tables::
    99 List of user permissions to tables::
   100 
   100 
   101   select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%';
   101   select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%';
   102 
   102 
       
   103 List of user privileges::
       
   104 
       
   105   select * from USER_SYS_PRIVS
       
   106   select * from USER_TAB_PRIVS
       
   107   select * from USER_ROLE_PRIVS
       
   108 
   103 Profiling.
   109 Profiling.
   104 ==========
   110 ==========
   105 
   111 
   106 Timing info about last queries::
   112 Timing info about last queries::
   107 
   113