What about through pg_hba.conf? We've set it up so to connect to a database, you must be in pg_pwd (through pg_passwd), and know the passwd. I will mention, that pg_pwd should not be clear text.
Any plan to encrypt it? At 06:12 PM 2/10/02 -0600, Chris Ruprecht wrote: >Jon, > >the only way I can think of doing this is by revoking the user's rights to >the tables of the databases they have no business in. > >I know this is not exactly the answer you're looking for ... > >Best regards, >Chris > >At 17:54 -0500 02/10/2002, Jon August wrote: >>Can I restrict a user to a single database? It seems like any user can >>connect to any database. . . >> >> -Jon >> >>--- >>Voice: (973) 560-9095 | Internection - Electronic Commerce, Internet >>Cell : (973) 801-6071 | Consulting and Grade A Web Hosting Since 1995. >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 5: Have you checked our extensive FAQ? >> >>http://www.postgresql.org/users-lounge/docs/faq.html > > >-- >Chris Ruprecht >Network grunt and bit pusher extraordina�re > >_________________________________________________________ >Do You Yahoo!? >Get your free @yahoo.com address at http://mail.yahoo.com > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Naomi Walker Chief Information Officer Eldorado Computing, Inc. 602-604-3100 ext 242 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
