Re: Users which aren't users?

Luke Tudor wrote:
>Hi,
>
>I am having slight problems adding users to my database. This problem has on
>ly recently occured since our systems were upgraded to Solaris 8 -- mayb
>e 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 unde
>rstand is why the user does not appear to be able to login to the databa
>se if the information has been writtern into this table.

What have you got in pg_hba.conf?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I saw in the night visions, and, behold, one like the
Son of man came with the clouds of heaven, and came to
the Ancient of days, and they brought him near before
him. And there was given him dominion, and glory, and
a kingdom, that all people, nations, and languages,
should serve him; his dominion is an everlasting
dominion, which shall not pass away, and his kingdom
that which shall not be destroyed."
Daniel 7:13,14