From: | Eric E <whalesuit(at)gmail(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How: single db, multiple users |
Date: | 2005-12-02 17:16:18 |
Message-ID: | 43908162.2080809@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Postgres' users are not specific to a database, they are shared across
all databases on a particular server.
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.
Hope that helps,
Eric
P G wrote:
>Greetings,
>
>I am new to PostgreSQL and come from an DB2
>background. I currently have v8.0.3 up and running.
>So far, it looks great!
>
>One area I am confused about is how to set up
>databases and users. I can currently create
>databases, but I am having difficulty in assigning
>mutiple users to those databases. For example, I have
>set up one database for a large project. There are
>several users that need to have access to that
>database: create tables, insert, delete, select,
>update, etc. The documentation talks about a single
>user-database associations but is not clear on how to
>have multiple users on a single database.
>
>Are there any best practices that I could follow in
>settings these up for various projects and databases?
>Or if this is a simple thing to do, any pointers on
>how to do it?
>
>
>
>
>
>
>
>
>
>
>__________________________________________
>Yahoo! DSL – Something to write home about.
>Just $16.99/mo. or less.
>dsl.yahoo.com
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-12-02 17:17:14 | Re: Numeric 508 datatype |
Previous Message | P G | 2005-12-02 17:06:54 | How: single db, multiple users |