top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
456 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 LinkedIn 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
...