Re: default role privileges

default privileges can be applied to roles (and, it appears, only to roles)

https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.html

ALTER DEFAULT PRIVILEGES
[ FOR { ROLE | USER } *target_role* [, ...] ]
[ IN SCHEMA *schema_name* [, ...] ]
*abbreviated_grant_or_revoke*

On Mon, May 13, 2019 at 4:58 AM Khushboo Vashi <
khushboo(dot)vashi(at)enterprisedb(dot)com> wrote:

>
>
> On Mon, May 13, 2019 at 3:06 PM Michael Shapiro <mshapiro51(at)gmail(dot)com>
> wrote:
>
>> 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.
>>
> Default privileges can be applied on tables, sequences, types and on
> functions only, so why roles?
>
>> I do see default privileges on the SQL for the database itself, but not
>> the one I added above.
>>
> You can create this bug @ https://redmine.postgresql.org/projects/pgadmin4 with
> the proper steps to reproduce it.
>
>> (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(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>>
>>>
>>> On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51(at)gmail(dot)com>
>>> wrote:
>>>
>>>> Where in PgAdmin4 can I see (and set) default privileges for a role?
>>>>
>>> Please refer
>>> https://www.pgadmin.org/docs/pgadmin4/4.x/role_dialog.html?highlight=Privileges
>>>
>>>
>>