Users which aren't users? - Mailing list pgsql-novice

From Luke Tudor
Subject Users which aren't users?
Date
Msg-id 20010824095638.1b7b3bcb.ltt@pml.ac.uk
Whole thread Raw
Responses Re: Users which aren't users?  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-novice
Hi,

I am having slight problems adding users to my database. This problem has only recently occured since our systems were
upgradedto Solaris 8 -- maybe this is part of the problem?. 

If I try to create a user using:
    "CREATE USER ttc WITH PASSWORD enter"

the user appears in the pg_shadow table (and pg_pwd file). What I don't understand is why the user does not appear to
beable to login to the database if the information has been writtern into this table. 

Any Ideas?
Thanks for your ongoing support.

Best Regards,
Luke.

pgsql-novice by date:

Previous
From: Bo Lorentsen
Date:
Subject: Identify an inherited table
Next
From: "Oliver Elphick"
Date:
Subject: Re: Users which aren't users?