Re: default role privileges

Поиск
Список
Период
Сортировка
От Khushboo Vashi
Тема Re: default role privileges
Дата
Msg-id CAFOhELckpCuaWYu6hCw6cpR81oZfQpGzb1vHgoAM34uRSxoFMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: default role privileges  (Michael Shapiro <mshapiro51@gmail.com>)
Ответы Re: default role privileges
Список pgadmin-support


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?

В списке pgadmin-support по дате отправления:

Предыдущее
От: Michael Shapiro
Дата:
Сообщение: Re: default role privileges
Следующее
От: Durumdara
Дата:
Сообщение: Re: Can't start 4.6