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.Elphick@lfix.co.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