How to find out vertica user list?

Answers

• LenoyJ - Select Field - Employee

  September 2020 edited September 2020

  https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/USERS.htm

  0
• Jim_Knicely - Select Field - Administrator

  September 2020 edited September 2020

  Also, in vsql you can issue the \du meta-command!

  Example:

  dbadmin=> \du
           List of users
     User name    | Is Superuser
  ----------------+--------------
   dbadmin        | t
   mygames         | f
   joe            | f
   ma_dbd         | f
   that_other_one | f
  (5 rows)
  
  

  https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/DPATTERNMeta-commands.htm

  0