From: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
---|---|
To: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: default role privileges |
Date: | 2019-05-13 09:36:07 |
Message-ID: | CAGCvxeYkhyuW9WjdKdHX6BNt0YrgTJy-seJ3wqVD0QJcEdjBxA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(dot)vashi(at)enterprisedb(dot)com> wrote:
>
>
> On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Khushboo Vashi | 2019-05-13 09:58:33 | Re: default role privileges |
Previous Message | Aditya Toshniwal | 2019-05-13 06:54:43 | Re: Can't start 4.6 |