[GENERAL] How: single db, multiple users

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

Re: [GENERAL] How: single db, multiple users

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

Re: [GENERAL] How: single db, multiple users

--- Eric E [EMAIL PROTECTED] 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