Re: Sorting out acl fixes

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Sorting out acl fixes
Дата
Msg-id 40FF3764.7030809@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Sorting out acl fixes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Sorting out acl fixes
Список pgsql-hackers
> The solution I had in mind was for ALTER OWNER to run through the ACL
> and replace the old owner ID with the new one wherever the old one
> appears, in both grantor and grantee positions.  So in your example
>     {chriskl=arwdRxt/chriskl,other=r/chriskl}
> becomes
>     {gumby=arwdRxt/gumby,other=r/gumby}
> 
> You could skip doing this when the ACL is null of course, since the
> default assumption about its contents will change in just the same way.

What about fixing existing bad acls?  I can't figure out a grant or 
revoke statement to do it?  Do I have to update to set the relacl to 
null and then re-run the fixed set of grants?

Chris



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sorting out acl fixes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Sorting out acl fixes