dropped users appear as numbers in ACL

Поиск
Список
Период
Сортировка
От DHS Webmaster
Тема dropped users appear as numbers in ACL
Дата
Msg-id 3FB3EB56.F40DA1DF@dhs-club.com
обсуждение исходный текст
Ответ на Re: easy way to copy all DBs and users on a server  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: dropped users appear as numbers in ACL  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-admin
I have experienced this in the past with members of groups, but now with
relation ACLs. It goes like this:
Certain users are given specific permissions of different tables and
such.
The users are later dropped but reference to them remains in the ACL as
their former ID number.
When trying to revoke permissions on the number, it fails.
I noticed this with groups in the past and have become accustomed to
deleting these users from the groups before dropping them. Otherwise I
had to create dummy users with those IDs, go about cleaning things out
and then drop the dummy user.
Will I have to perform this same procedure for ACLs?
Are there any plans to handle these issues transparently when a user is
dropped?
--
Bill MacArthur
Webmaster
DHS Club

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

Предыдущее
От: Naomi Walker
Дата:
Сообщение: Re: Upgrading to Solaris 9
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: dropped users appear as numbers in ACL