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!"
-----------------------------------------------------------------------------