How to query given grants on Oracle? 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;
Try this:

select * from user_sys_privs