[ADMIN] Users and Roles

2007-01-31 Thread Sidar López Cruz 

How can I create a role and some reestrictions on it?
The case is that I have many databases and thousands of users, I need to 
create users and these users can only connect to only one database and no 
more.


Please help me.

_
Charla con tus amigos en línea mediante MSN Messenger: 
http://messenger.latam.msn.com/



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

Re: [ADMIN] Users and Roles

2007-01-31 Thread Matthias . Pitzl 
> -Original Message-
> How can I create a role and some reestrictions on it?
> The case is that I have many databases and thousands of 
> users, I need to 
> create users and these users can only connect to only one 
> database and no 
> more.
> 
> Please help me.
> 

Hello Sidar!

Perhaps you should read these pages in the documentation:
http://www.postgresql.org/docs/8.2/interactive/user-manag.html and
following.

Greetings,
Matthias

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq