From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to configure PostgreSQl for low-profile users |
Date: | 2009-03-18 20:54:52 |
Message-ID: | 20090318205452.GF32672@frubble.xen.chris-lamb.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 18, 2009 at 09:15:31PM +0100, dfx wrote:
> It is possible to configure the security policy so that the simple users
> (the customer, in this case) can only read, write, update end delete data to
> the dedicated database AND NOTHING ELSE, particularly:
I assume you're implying a caveat saying "modulo bugs" in there?
> - I would like to create each database with a different (customer) username
> (only one per database, in addition to the standard user postgres)
OK
> - The user (customer):
> ---- cannot change his own username and the password
Users aren't, by default, allowed to change their name in PG. They can
of course change their password, why would you want to stop this??
> ---- cannot backup the database
Well, anyone that can read a table can backup the tables they can read.
Could you define this a bit better?
> ---- cannot read (the text of) the stored procedures, but execute only
I believe this can be tied down, yes.
> ---- cannot know the 'existence' of the other databases
I think this is a little trickier to arrange, why would it matter?
--
Sam http://samason.me.uk/
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2009-03-18 21:00:18 | Re: How to configure PostgreSQl for low-profile users |
Previous Message | Bryan Herger | 2009-03-18 20:32:41 | ORDER BY: lexicographic ordering of names |