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