
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


Fri, 25 Jan 2002 08:12:31 
"omid omoomi" <oomoomi@hotmail.com>
Re: Database access right
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
> >anyway to restrict that?
> >
> >
> >Regards,
> >Lau NH
> >
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com


Fri, 25 Jan 2002 16:46:13 +0800
"Lau NH" <launh@perridot.com>
Re: Database access right