Thread

1. create user

   Marcos <marcos@second.ival.es> — 2001-03-26T17:04:00Z

   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
   
   
   
   

2. Re: create user

   Alfonso Peniche <alfonso@iteso.mx> — 2001-03-30T00:37:38Z

   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)