Re: How to remove user specific grant and revoke

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to remove user specific grant and revoke
Дата
Msg-id c8a918fa-3f8a-0ddd-12a9-85d8b24f3e22@hot.ee
обсуждение исходный текст
Ответ на How to remove user specific grant and revoke  (Andrus <kobruleht2@hot.ee>)
Ответы Re: How to remove user specific grant and revoke
Список pgsql-general

Hi!

I tried

alter role  alekspoluh reset all

After this command pgAdmin still shows revoke and grant commands for alekspoluh  role.

How to remove all grant and revoke assignments for role ?


Andrus.

03.06.2023 20:50 Andrus kirjutas:

Hi!
> REVOKE must be executed by the grantor (sba_owner) or a superuser in case you

not already tried that.  
REVOKE was executed by superuser, postgres. PgAdmin uses this user to log on.
Do you get any errors?

There are no errors.

Andrus.

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

Предыдущее
От: Erik Wienhold
Дата:
Сообщение: Re: How to remove user specific grant and revoke
Следующее
От: Erik Wienhold
Дата:
Сообщение: Re: How to remove user specific grant and revoke