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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > >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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
