Postgres Pro
Downloads
Home   >   mailing lists

Re: Group role not shown in properties > Default Privileges after adding it - Mailing list pgadmin-support

From Aren Cambre
Subject Re: Group role not shown in properties > Default Privileges after adding it
Date
Msg-id CAA1mBrqE32TDCuOkwvsW6DykAs1D=HhPDsK44S4-GdTEzfZiuQ@mail.gmail.com
Whole thread Raw
In response to Group role not shown in properties > Default Privileges after adding it  (Aren Cambre <aren@arencambre.com>)
Responses Re: Group role not shown in properties > Default Privileges after adding it
List pgadmin-support
Tree view
One correction. I wrote "group role", but I think it's actually a login role. Here's its SQL:
CREATE ROLE gis LOGIN
  ENCRYPTED PASSWORD 'md5d1eac6a9b9835a37d71bac718a80a7ac'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

On Sun, May 27, 2012 at 9:03 AM, Aren Cambre <aren@arencambre.com> wrote:
I added a group role named gis to a database using pgAdmin III 1.14.2 using the Default Privileges tab of the db's properties.

I can confirm it worked because if I click on the db, this shows up at the bottom of its SQL:
ALTER DEFAULT PRIVILEGES 
    GRANT SELECT ON TABLES
    TO gis;

However, if I right-click on the db, go to Properties, then select the Default Privileges, it does not show any group roles:
Inline image 1

Near the bottom of the pgAdmin Object browser, under Group Roles is this role:
Inline image 2

Aren

Attachment

pgadmin-support by date:

Previous
From: Alexandr Ciornii
Date:
Subject: incorrect charset in HTML report
Next
From: Andreas
Date:
Subject: Drag & Drop in SQL editor ?