Re: [GENERAL] adding a db-specific user
On Fri, Jul 09, 2004 at 17:06:20 +, Sally Sally <[EMAIL PROTECTED]> 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
[GENERAL] 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 ---(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