Re: [GENERAL] Can't get pgsql 8.1.4 to password protect roles.

2006-06-03 Thread Tom Lane
"Will Buik" <[EMAIL PROTECTED]> writes: > I'm trying to password protect both the superuser role and another role that > I created later with less privileges but I can't seem to get it to work. I > have tried using the command *ALTER USER user WITH PASSWORD 'password';* and > it responds with *ALT

[GENERAL] Can't get pgsql 8.1.4 to password protect roles.

2006-06-03 Thread Will Buik
I'm trying to password protect both the superuser role and another role that I created later with less privileges but I can't seem to get it to work.  I have tried using the command ALTER USER user WITH PASSWORD 'password'; and it responds with ALTER ROLE but it seems to have no effect at all.  Ev