Re: create user
Alfonso Peniche <alfonso@iteso.mx>
From: Alfonso Peniche <alfonso@iteso.mx>
To: Marcos <marcos@second.ival.es>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2001-03-30T00:37:38Z
Lists: pgsql-general
As of now, every user you create has access to any database you have (unless this has changed in 7.1 ). I don't think there's a way to avoid this for now. Marcos wrote: > hi, > > i have just created a new database. I would like to add, now, a new > user. The user can make any changes in THIS database (no one else). > i used: (from NEW database) > create user new_user with password "new_pass"; > i try to connect to another database with this new_user and i did > it. how can i prevent this option? > > best regards, > > marcos > marcos@ival.es > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)