[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Ledgersmb Authentication issue



Hi Steven,

Trying the command you provided, it prompted me for the password and upon entering it returned a Fatal error indicating password authentication failed. ÂI then tried the following in psql:

Alter User neidiane.pereira WITH PASSWORD 'somepassword';

This returned an error indicating a syntax error at or near the "." in the name. ÂIt appears not to like the use of a period in the name although tatiane.marshall works correctly.


You should be able to run the command Â$ ALTER USER Â"neidiane.pereira" WITH PASSWORD 'somepassword';

The double quotes delimit the user name with characters which would have otherwise meaning in SQL.

HTH,

Erik.