Re: pgadmin user access control features

From: "Mark Felder" <feld(at)feld(dot)me>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgadmin user access control features
Date: 2011-01-04 19:39:54
Message-ID: op.vost8ru534t2sn@tech304
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 04 Jan 2011 11:04:56 -0600, Dan Sabin <dan(dot)sabin(at)nextwavesys(dot)com>
wrote:

> The two options are to give them a query tool we design so we can
> restrict their actions (to prevent the database from being screwed up).

If their user still has access to doing other things it might be possible
for that data to be modified using regular postgres tools, which is a a
security risk of sorts. Perhaps it might be best for you to setup certain
functions or stored procedures that their database user only has access
to? I assume this is possible, anyway.

Regards,

Mark

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Victor Hugo dos Santos 2011-01-04 19:57:24 Re: ERROR: invalid memory alloc request size 4294967293
Previous Message Kevin Grittner 2011-01-04 18:04:38 Re: pgadmin user access control features