Why does ALTER AUTHORIZATION on a table drop all permissions on the target?
Because the new owner don't want to be given an object that a bunch of other people has access to?
Imagine buying a new house. Do you expect other folks to have access to your new house? Or would you say that it is up to you to hand out the keys/codes to your new house - to the people you trust?
It is hard to respond to &quot;why&quot; questions, since we'd have to been in the meeting when this was decided in order to hear the reasoning going back and forth. But above is my guess.
(I thought about this possibly being from the SQL standard, but it doesn't seem like there's an ALTER AUTHORIZATION command in ANSI/ISO SQL...?)