Re: User Management
От | D. Duccini |
---|---|
Тема | Re: User Management |
Дата | |
Msg-id | Pine.GSO.4.03.10107041747250.3307-100000@ra.bpsi.net обсуждение исходный текст |
Ответ на | User Management ("Chris Cameron" <chris@UpNIX.com>) |
Ответы |
RE: User Management
|
Список | pgsql-novice |
use the "createuser" command On Wed, 4 Jul 2001, Chris Cameron wrote: > Coming from a MySQL background, the way PostgreSQL deals with users > seems whacked out to say the least. And that's where I'm having my > problem. > > Now in my pg_hba.conf file I have; > local all password > local chris password passwd > > so when I go 'select * from pg_shadow' I see the root user I added with > 'create user'. With this user I can log into any database and create any > database. Which is perfect. However, my problem comes in when I try > delegate access to different databases for different users. Say I want > the user 'joe' to have access to the database 'chris'. The way I tried > to do this is in the file 'passwd' I added; > joe:joepass > > which is in the same directory as my pg_hba.conf. Not only does it seem > Postgres isn't reading this file, but how can I have 'joe' own the > database when a database is owned my whoever made it? Joe doesn't have > the ability to create databases because I only want joe to play with his > own database. > > Needless to say I'm confused. I've scoured the online manuals, and the > PostgreSQL book is next to useless for indepth administration. > > Any help, pointers, or links would be much appreciated, > > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > ----------------------------------------------------------------------------- david@backpack.com BackPack Software, Inc. www.backpack.com +1 651.645.7550 voice "Life is an Adventure. +1 651.645.9798 fax Don't forget your BackPack!" -----------------------------------------------------------------------------
В списке pgsql-novice по дате отправления: