adding a db-specific user
I was wandering how I can add a user to a specific db. There are several
databases but I want to add the user to only one of them. It seems when I
add a new user, it is entered in the pg_user table and I can log in to any
one of the other dbs (ofcourse I won't be able to do anything until I grant
permission still I don't even want to be able to log in to the other dbs and
see the db schema etc).
Does anybody know how to avoid this?
Thanx
Sally
_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee�
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
On Fri, Jul 09, 2004 at 17:06:20 +0000,
Sally Sally <dedeb17@hotmail.com> wrote:
I was wandering how I can add a user to a specific db. There are several
databases but I want to add the user to only one of them. It seems when I
add a new user, it is entered in the pg_user table and I can log in to any
one of the other dbs (ofcourse I won't be able to do anything until I grant
permission still I don't even want to be able to log in to the other dbs
and see the db schema etc).
Does anybody know how to avoid this?
You can control this in pg_hba.conf.