Database access right

Hi ,
Look at pg_hba.conf file usually under /usr/local/pgsql/data .
regards
Omid Omoomi

From: "Lau NH" <launh@perridot.com>
To: <pgsql-admin@postgresql.org>, <pgsql-hackers@postgresql.org>
Subject: [ADMIN] Database access right
Date: Fri, 25 Jan 2002 13:39:14 +0800

Hi all,
Is there anyway to restrict the database owner to access only to
his/her database? because if I assign the dba right to the database owner,
he/she will be able to access other databases in the same server. Is there
anyway to restrict that?

Regards,
Lau NH

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

My case is like this, my database server has a grant DBA "postgres" who can
access all the database, and I have individual database's dba, e.g. "user1"
as dba for database "db1", "user2" as dba for database "db2", and so on.
How am I going to set this up in pg_hba.conf?

Regards,
Lau NH

----- Original Message -----
From: "omid omoomi" <oomoomi@hotmail.com>
To: <launh@perridot.com>; <pgsql-admin@postgresql.org>;
<pgsql-hackers@postgresql.org>
Sent: Friday, January 25, 2002 8:12 AM
Subject: Re: [ADMIN] Database access right

Hi ,
Look at pg_hba.conf file usually under /usr/local/pgsql/data .
regards
Omid Omoomi

From: "Lau NH" <launh@perridot.com>
To: <pgsql-admin@postgresql.org>, <pgsql-hackers@postgresql.org>
Subject: [ADMIN] Database access right
Date: Fri, 25 Jan 2002 13:39:14 +0800

Hi all,
Is there anyway to restrict the database owner to access only to
his/her database? because if I assign the dba right to the database

owner,

he/she will be able to access other databases in the same server. Is

there