Who am I?

SarahLSarahL Administrator, Moderator, Employee, Registered User, VerticaExpert, CABuser
edited May 16 in Vertica Tips

Jim Knicely authored this tip.

There are several ways to figure out who the session user is. This comes in handy for logging.

Example:

[dbadmin@s18384357 ~]$ vsql -U jim
Welcome to vsql, the Vertica Analytic Database interactive terminal.

Type:  \h or \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit

jim=> select user;
current_user
--------------
jim
(1 row)

jim=> select current_user();
current_user
--------------
jim
(1 row)

Have fun!

Sign In or Register to comment.