ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_revoke
target_role
schema_name
abbreviated_grant_or_revoke
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
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 SQL for the database itself, but not the one I added above.
(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
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
Where in PgAdmin4 can I see (and set) default privileges for a role?
pgadmin-support by date:
Соглашаюсь с условиями обработки персональных данных