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