need some help..securing multiple databases/users

From: Frank Nijenhuis <fnijen(at)bos(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: need some help..securing multiple databases/users
Date: 2001-02-08 10:23:29
Message-ID: Pine.LNX.4.10.10102081110070.24481-100000@wnet.bos.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hai ppl,
I'm setting up a postgresql server to be used by several customers for
webapplications. We mainly use mysql here and sybase and our third
database platform has to be postgres. Read the documentations, read the
books but I still miss information and I don't feel like I got my fingers
behind it.

Setup should be simple. Create one user, create one database. Users are
not allowed to create other users or databases. They should be stuck
within their database and have all create rights in that database.
In time maybe some more users should be added to that database where the
initial user should give them rights to the objects within that database.

1) I create a user as user postgres with the options not to be allowed to
create other databases or users
2) I set his password with the alter statement
3) I create a database.....

a) how do I appoint this database to that user? Or how do I have a user
"own" a database?
I would like the situation where they login, get appointed to their
database and never be able to "use" another database.
How can 2 users have the create table right on a database? The grant
statement doesn't have the "create" rights, only insert, update etc
on objects. Adding more users to a specific database, can that only be
done by the using groups concept?

b) Insight in the systemtables would be nice, is their any documentation
on that subject? Is it possible to reverse engineer them?

Maybe someone answer my questions? Or some hints where to look for more
info.

Thanx

Frank

Browse pgsql-general by date

  From Date Subject
Next Message Einar Karttunen 2001-02-08 10:50:41 Re: Auto-timestamp generator (attached)
Previous Message Richard Huxton 2001-02-08 10:07:31 Auto-timestamp generator (attached)