Re: [ADMIN] User Management, drop users

2007-01-14 Thread Tom Lane
Sven Sporer <[EMAIL PROTECTED]> writes: > 2) How do you restrict the users of a specific database to touch only > the objects in their database? They *are* so restricted. Your problem is that roles are installation-wide, not local to a particular database, and so you cannot enforce the restrict

[ADMIN] User Management, drop users

2007-01-14 Thread Sven Sporer
Hi, I felt that this place is more appropriate to ask my question. I already posted at psql-novice, but got no response. Here we go: Right now, I have the following user management concept: -) when creating a database, an equally named role is created; every user of this db is in this role, t