From: | P G <pgress5(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How: single db, multiple users |
Date: | 2005-12-02 19:29:38 |
Message-ID: | 20051202192938.90132.qmail@web36307.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- Eric E <whalesuit(at)gmail(dot)com> wrote:
> At the database level, you can assign creation and
> other permissions to
> users, but (AFAIK) you cannot deny users to a
> database. However, you can
> effectively control users' access to a particular
> database by granting
> or denying them access to a schema within that
> database.
Eric,
Thanks for the carification. It is quite helpful for
me early in my introduction to PostgreSQL.
So that I hear you correctly, it is OK then for only
one user to be the owner of a database. Then I will
give other users privileges on a one by one basis.
And I can do this for a particular schema in a
database or all schemas in it, without enumerating all
the tables in those schemas? Am I correct?
What kind of privileges do I need to give other users
so that they can create tables, delete them, update
them, etc. in that database? Can I use "ALL"
priveleges here?
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
From | Date | Subject | |
---|---|---|---|
Next Message | Harakiri | 2005-12-02 19:33:53 | deadlock detected - when multiple threads try to update one table |
Previous Message | Jan Wieck | 2005-12-02 19:28:53 | Re: Slow COUNT |