Re: Users which aren't users?

	Problem resolved;
	It seemed to be due to some difference in the encrypted password file to pg_shadow.
	I altered the password in this file and all's well again.
	Thanks very much for your help -- it's really appriciated.

	Luke

On Fri, 24 Aug 2001 10:54:04 +0100
"Oliver Elphick"  wrote:

> 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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 


-- 

Best Regards,
Luke.

_______________________________________________________________________
Mr L. T. Tudor, Remote Sensing Group   Ph,Fx: +44 (0)1752 633151,633101
CCMS Plymouth Marine Laboratory,       E-mail: ltt@ccms.ac.uk 
Prospect Place, Plymouth PL1 3DH, UK   Web site: www.npm.ac.uk/rsdas/
_______________________________________________________________________