can't revoke users

Поиск
Список
Период
Сортировка
От Scott Cotton
Тема can't revoke users
Дата
Msg-id 2526be2b0802081601k64eb324dk8ac776659347ecde@mail.gmail.com
обсуждение исходный текст
Ответы Re: can't revoke users
Список pgsql-admin
I have a database that I dropped some users on. However, when doing dumps and restores, it became clear that these users were still being referenced by sysid. So I created new users and assigned them the sysids of the users I had dropped.

So now I went to revoke the privileges for the new (temp) users. However, some tables I can revoke the users and some I cannot.
I also tried to drop one of the new users I created and it created the same situation as before, where the user still shows up with priveleges, but instead of listing a name it lists a sysid.

Any ideas?

Thanks,
Scott

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Help calculating load values
Следующее
От: "dghundt@netzero.net"
Дата:
Сообщение: pg_dump on windows