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
|
Список | 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 по дате отправления: