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!
Active Session Roles
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Active Session Roles
Hi,
In vsql you can view which roles are enabled for the current user session like this:
Hope this helps!
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)
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Active Session Roles
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!
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!