Thread: 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.