How can i know the users that are loged in
How can i know the users that are loged in
От:
Vasilis Ventirozos <vendi@cosmoline.com>
Дата:
Hi all i want to ask something about user managment , How can i know the users that are loged thru an SQL command or how can i know who i am (my username) thru SQL again i can see that the users are loging so when i connect to a database a triger (maybe) raises an notise that user vasilis is loged in Thanx in advance Vasilis Ventirozos
Re: How can i know the users that are loged in
От:
Antonis Antoniou <a.antoniou@albourne.com>
Дата:
Vasilis Ventirozos wrote: >Hi all i want to ask something about user managment , > >How can i know the users that >are loged thru an SQL command >or how can i know who i am (my username) thru SQL again > >i can see that the users are loging so when i connect to a database >a triger (maybe) raises an notise that user vasilis is loged in > If I understood correctly you need the query below: SELECT * from pg_stat_activity;