Re: user to database restriction?
От | Naomi Walker |
---|---|
Тема | Re: user to database restriction? |
Дата | |
Msg-id | 4.2.2.20020211085148.00ade100@ecint.ecinet.com обсуждение исходный текст |
Ответ на | Re: user to database restriction? (Chris Ruprecht <chrup999@yahoo.com>) |
Список | pgsql-admin |
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 majordomo@postgresql.org -- Naomi Walker Chief Information Officer Eldorado Computing, Inc. 602-604-3100 ext 242
В списке pgsql-admin по дате отправления: