Skip to main content
Question

How to find out vertica user list?

  • September 4, 2020
  • 2 replies
  • 5 views

HyeontaeJu
Forum|alt.badge.img+2

How to find out vertica user list?

2 replies

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • September 4, 2020

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • September 4, 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