Viewing Enabled and Available Roles
You can list the roles you have enabled in your session using the SHOW ENABLED ROLES statement:
=> SHOW ENABLED_ROLES; name | setting ---------------+---------- enabled roles | logreader (1 row)
You can find the roles available to your account using the SHOW AVAILABLE ROLES statement:
Bob=> SHOW AVAILABLE_ROLES; name | setting -----------------+----------------------------- available roles | logreader, logwriter (1 row)