List permissions

select * from USER_TAB_PRIVS

SELECT * FROM USER_SYS_PRIVS;

SELECT * FROM USER_ROLE_PRIVS;



select * from database_properties  where property_name like 'DEFAULT%TABLESPACE';