Re: Database Users Management and Privileges - Mailing list pgsql-hackers

From Gunnar Rønning
Subject Re: Database Users Management and Privileges
Date
Msg-id m266d6jdt6.fsf@smaug.polygnosis.com
Whole thread Raw
In response to Re: Database Users Management and Privileges  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Database Users Management and Privileges  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
* Peter Eisentraut <peter_e@gmx.net> wrote:
|
| Jean-Francois Leveque writes:
| 
| > Comming from Oracle, I was disapointed that
| > the users were not "per individual database".
| 
| > Is there any chance that this will change in
| > the future ?
| 
| Most likely not.  For one thing, it would be a problem to assign owners to
| databases.
| 

Why ? Better user management and policy delegations would be important
postgresql to succeed in enterprise environments. Maybe one should 
start distinguishing logins from users like Sybase does. Logins are global
to all databases, and you can create a user for a given database and assign
it to a login. It would also be nice to be able to assign users to 
groups(which in turn define access rights within the database). 

regards,
       Gunnar

-- 
Gunnar Rønning - gunnar@polygnosis.com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: AW: AW: Re: Backup and Recovery
Next
From: Matthew Hagerty
Date:
Subject: Re: Proper use of select() parameter nfds?