Skip to main content
Question

How to find out vertica user list?

  • Sep 4, 2020 6:05 AM UTC
  • 2 replies
  • 13 views

HyeontaeJu
Forum|alt.badge.img+2

How to find out vertica user list?

2 replies

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • Sep 4, 2020 6:20 AM UTC

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Sep 4, 2020 10:21 AM UTC

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