Postgres Pro
Downloads
Home   >   mailing lists

Re: default role privileges - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: default role privileges
Date
Msg-id CAGCvxeYkhyuW9WjdKdHX6BNt0YrgTJy-seJ3wqVD0QJcEdjBxA@mail.gmail.com
Whole thread Raw
In response to Re: default role privileges  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Responses Re: default role privileges  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
List pgadmin-support
Tree view
I ran this in one of my databases

 ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:

I can not see this default privilege anywhere in PgAdmin4 (nor in PgAdmin3).
I see no default privileges for roles on the SQL for the role.
I do see default privileges on the SQL for the database itself, but not the one I added above. 
(Also, the last example on the help page show creating an EDB role, but the discussion below talks about a role called "alice")

On Sun, May 12, 2019 at 11:56 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:


On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51@gmail.com> wrote:
Where in PgAdmin4 can I see (and set) default privileges for a role?

pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: Can't start 4.6
Next
From: Khushboo Vashi
Date:
Subject: Re: default role privileges