Determine User Session Privs

Log in as the user you want to know about and run this command:

 select * from session_privs;