Re: default role privileges

On Mon, May 13, 2019 at 8:18 PM Michael Shapiro <mshapiro51(at)gmail(dot)com>
wrote:

> default privileges can be applied to roles (and, it appears, only to roles)
>
> https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.html
>
You can find the default priviledges on the database, and schema properties
dialog.

[image: Screenshot 2019-05-14 at 11.11.22 AM.png]

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
<http://www.enterprisedb.com/>

*http://www.linkedin.com/in/asheshvashi*
<http://www.linkedin.com/in/asheshvashi>

>
>
> 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
>>>>
>>>>
>>>