We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Who am I? — Vertica Forum

Who am I?

[Deleted User][Deleted User] Administrator
edited May 2018 in Tips from the Team

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.