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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
