create user
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
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:
Show quoted text
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)