Re: default role privileges - Mailing list pgadmin-support

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

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

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company

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.vashi@enterprisedb.com> wrote:

On Mon, May 13, 2019 at 3:06 PM Michael Shapiro <mshapiro51@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.vashi@enterprisedb.com> wrote:

On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51@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