From: | "D(dot) Duccini" <duccini(at)backpack(dot)com> |
---|---|
To: | Chris Cameron <chris(at)UpNIX(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: User Management |
Date: | 2001-07-04 22:47:41 |
Message-ID: | Pine.GSO.4.03.10107041747250.3307-100000@ra.bpsi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
>
-----------------------------------------------------------------------------
david(at)backpack(dot)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!"
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | D. Duccini | 2001-07-04 23:01:18 | RE: User Management |
Previous Message | Chris Cameron | 2001-07-04 22:41:51 | User Management |