current database privileges

To find out what privileges a user currently uses:

login as the user

select * from session_roles -- gives the current roles the user can use.
select * from session_privs -- gives the current privs the user can use.