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
On Mon, May 13, 2019 at 3:06 PM Michael Shapiro
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 f
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 SQ
On Sun, May 12, 2019 at 7:42 PM Michael Shapiro
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
Where in PgAdmin4 can I see (and set) default privileges for a role?
