# HG changeset patch # User Oleksandr Gavenko # Date 1412094628 -10800 # Node ID 0fa6542d8c93c0882c7641df8ca9bc3b63f7137f # Parent baf11017516f6d1e38323e334f1b2b8a33355680 List of user privileges. diff -r baf11017516f -r 0fa6542d8c93 oracle.rst --- a/oracle.rst Tue Sep 30 19:13:46 2014 +0300 +++ b/oracle.rst Tue Sep 30 19:30:28 2014 +0300 @@ -100,6 +100,12 @@ select * from ALL_TAB_PRIVS where TABLE_SCHEMA not like '%SYS' and TABLE_SCHEMA not like 'SYS%'; +List of user privileges:: + + select * from USER_SYS_PRIVS + select * from USER_TAB_PRIVS + select * from USER_ROLE_PRIVS + Profiling. ==========