Active Session Roles

[usli06]

Hi guys,

Is there a simple way to check what roles are active for my session in vsql? Something like the session_roles table in Oracle which only lists the roles which are enabled for a session.

I was hoping there may be meta-command for this.

Thanks!

[JimKnicely]

Hi,

In vsql you can view which roles are enabled for the current user session like this:

Code: Select all

dbadmin=> SHOW enabled_roles;
     name      |         setting
---------------+--------------------------
 enabled roles | dbadmin, pseudosuperuser
(1 row)

Hope this helps!

[usli06]

Thanks, Jim!

Is there anyway to query the active roles? I am asking because we may need to know the roles that are active so we can control what a user sees in a simple app we're creating that uses odbc to connect to the database. We are not using vsql.

Thanks for your help!