From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | durumdara <durumdara(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Extending Session / Logged User info |
Date: | 2012-01-31 13:22:04 |
Message-ID: | 1328016124.3206.9.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 2012-01-31 at 04:16 -0800, durumdara wrote:
> Dear PGSQL Masters!
>
> I have a complicated question.
>
> Is there any way to extend the session information (what visible in
> pgadmin's "Server Status")?
>
> I explain what I want to do:
>
> We used alternative DB in a place and I need to port this.
> In this DB we using different db users for every real users.
> When the program logging to the server it input for username/pwd, and
> log with it.
> So if John XY logged in, the session is shown as "John XY", which is a
> real user, and db user too.
>
> This meaning that if we have 80 users, we need to create 80 db users.
>
> It is very useful when you want to see who use the db, but very tiring
> when you want to create or manage them (plus role, etc).
>
Creating 80 users is not a really big burden. Managing privileges for 80
users will be. So you need to create some roles, on which you'll
grant/revoke privileges, and you'll make each user member of one or more
of the roles.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
PostgreSQL Sessions #3: http://www.postgresql-sessions.org
From | Date | Subject | |
---|---|---|---|
Next Message | Durumdara | 2012-01-31 14:19:32 | Re: Extending Session / Logged User info |
Previous Message | Marti Raudsepp | 2012-01-31 13:14:54 | Re: Why Hard-Coded Version 9.1 In Names? |