[ADMIN] database privileges and access control

2003-03-10 Thread Roman Gavrilov
Hello, I have 2 questions. The first one (I know it been discussed already, but I did not find the solution). If I have user A and user B and database DB1 and database DB2 and only local connections. How can I configure the pg_hba.conf to let user A connect only to the DB1 database and let use

[ADMIN] database privileges and access control

2003-03-09 Thread Roman Gavrilov
Hello, I have 2 questions. The first one (I know it been discussed already, but I did not find the solution). If I have user A and user B and database DB1 and database DB2 and only local connections. How can I configure the pg_hba.conf to let user A connect only to the DB1 database and let user B

Re: [ADMIN] Database Privileges

2001-01-17 Thread R D
I would like to see some restrictions on who can or who can not create things in a database too. Hoping too see this soon Rumen --- Markus Wigge <[EMAIL PROTECTED]> wrote: > Hi PG-Admins, > > I think this question is asked more often than > you'd like it to be > so excuse me ... > Is

[ADMIN] Database Privileges

2001-01-17 Thread Markus Wigge
Hi PG-Admins, I think this question is asked more often than you'd like it to be so excuse me ... Is there any possibility to restrict database-access user based? When I create a user without the permission to create databases this user has access to all available databases on the syste