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.va...@enterprisedb.com> wrote: > > > On Mon, May 13, 2019 at 3:06 PM Michael Shapiro <mshapir...@gmail.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.va...@enterprisedb.com> wrote: >> >>> >>> >>> On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapir...@gmail.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 >>> >>> >>
