User Management
От | Chris Cameron |
---|---|
Тема | User Management |
Дата | |
Msg-id | CPECLBOMCGAECJLMHKMDCEMPCAAA.chris@UpNIX.com обсуждение исходный текст |
Ответы |
Re: User Management
|
Список | pgsql-novice |
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
В списке pgsql-novice по дате отправления: