List admins in Vertica

Article for: SQL Server Amazon Redshift

Query below returns list of admins in Vertica database.

Query

select user_name,
       all_roles,
       is_super_user,
       is_locked,
       lock_time
from v_catalog.users
where all_roles like '%pseudosuperuser%' 
order by user_name;

Columns

  • user_name - user name
  • all_roles - all roles granted to user
  • is_super_user - flag if user is default vertica superuser
  • is_locked - flag indicating if user is locked
  • lock_time - date when user account was locked

Rows

  • One row represents one admin in the database
  • Scope of rows: all admins in Vertica database
  • Ordered by user name

Sample results

sample results

0
There are no comments. Click here to write the first comment.