| From: | "Will Buik" <willbuik(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Can't get pgsql 8.1.4 to password protect roles. |
| Date: | 2006-06-03 18:36:03 |
| Message-ID: | 1d09f8b80606031136s2162c00dxed968bb06a23078b@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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. Even
after I've password protected the role I can login to it with the
*psql*command without a password. Even when I force it to prompt for
the password
with *-W*, I can type anything into the prompt and it still lets me in. I
have made no alterations to the configuration files, and to the extent of my
knowledge the compilation was standard other than *PREFIX*. Does anyone
know what I have done wrong here?
PS. Sorry if this is a really stupid question, I'm new to pgsql.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-06-03 21:40:52 | Re: Best high availability solution ? |
| Previous Message | Harald Armin Massa | 2006-06-03 16:17:16 | Re: Using postgresql as desktop DB |