top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How to see what privileges received to user by owner user?

0 votes
26 views
How to see what privileges received to user by owner user?
posted Jul 30, 2015 by Viswas Kumar

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

2 Answers

+1 vote

select privilege
from dba_sys_privs
where grantee='SCHEMA_NAME'
order by 1;

answer Jul 31, 2015 by Arif Shaikh
0 votes

we have to use

USER_TAB_PRIVS_RECD
USER_COL_PRIVS_RECD
answer Jul 31, 2015 by Arun Gowda
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...