| From: | Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | No Password Access | 
| Date: | 2011-02-08 22:36:30 | 
| Message-ID: | AANLkTim32UNsiUogbcCW4ShOKAcSenHc=t-g2QgGbLB4@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Today on a new PostgreSQL 9.0.3 server I created a new user:
CREATE ROLE carlos LOGIN CREATEDB CREATEROLE;
CREATE ROLE
I then set a password and comment on the user:
ALTER ROLE carlos WITH PASSWORD 'letmein';
ALTER ROLE
COMMENT ON ROLE carlos IS 'Database Administrator';
COMMENT
So I now try to connect to the database from my desk workstation:
carlos(at)laptop:~$ psql -h db1 -d postgres
psql (8.4.7, server 9.0.3)
WARNING: psql version 8.4, server version 9.0.
         Some psql features might not work.
Type "help" for help.
postgres=> SELECT current_user;
 current_user
--------------
 carlos
(1 row)
postgres=> \du
            List of roles
 Role name | Attributes  | Member of
-----------+-------------+-----------
 carlos    | Create role | {}
           : Create DB
 maggie    | Create DB   | {}
 postgres  | Superuser   | {}
           : Create role
           : Create DB
Why am I not prompted for a password when I connect from my laptop to
the server? I didn't grant attributes of 'INHERIT' to carlos so
shouldn't I be prompted for my password? Am I missing something here?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Christensen | 2011-02-08 22:44:51 | Re: Permission denied error - best way to fix? | 
| Previous Message | Thom Brown | 2011-02-08 22:36:10 | Re: Displaying text appears as hex data |