How to query given grants on Oracle?

Question

On a database I had to execute the following two statements:

GRANT CREATE ANY TABLE TO MyUSER;
GRANT DROP ANY TABLE TO MyUSER;

What I miss is the query which tells me that those grants are given. I don't see them in

select * from USER_TAB_PRIVS ORDER BY 2 ;
select * from USER_ROLE_PRIVS ORDER BY 1, 2;

Vijay · Accepted Answer · 2011-09-20 11:24:34Z

11

Try this:

select * from user_sys_privs

answered Sep 20, 2011 at 11:24

Vijay

1261 silver badge2 bronze badges

1

Correct. As "CREATE ANY TABLE" is not a table privilege (tied to a specific table) it's not listed in XXX_TAB_PRIVS.
– user1822
Commented Sep 20, 2011 at 11:28
1

I'll give you a hint for in the future @Vijay ... A longer answer is better. Maybe a tiny blurb about why they would do this?
– jcolebrand ♦
Commented Sep 20, 2011 at 18:22

Add a comment |

1 Answer 1