adding a db-specific user

[Sally Sally]

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...n.asp?cid=3963
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Bruno Wolff III]

On Fri, Jul 09, 2004 at 17:06:20 +0000,
Sally Sally <de*****@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.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings