determine who is log into Vertica database

Moderator: NorbertKrupa

Post Reply
brendon987
Newbie
Newbie
Posts: 17
Joined: Wed Sep 12, 2012 8:28 pm

determine who is log into Vertica database

Post by brendon987 » Wed Jan 16, 2013 5:31 pm

How do I determine who is log into Vertica database ? and how to I kick them off ?

Thanks

Brendon
Top
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:
Contact JimKnicely

Re: determine who is log into Vertica database

Post by JimKnicely » Wed Jan 16, 2013 5:43 pm

Hi!

You can query the SESSIONS system table to determine the users that are connected:

Example:

Code: Select all

dbadmin=> select user_name from sessions;
 user_name
-----------
 dbadmin
(1 row)
To kick a user off, check out this post:

viewtopic.php?f=3&t=95
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Top
Post Reply

Return to “New to Vertica”