I think a more useful change (if any) would be a NOTICE or WARNING when granting privs on a object in a schema, to a user who does not already have privs on the schema itself.
Definitely not a warning but maybe a notice. But if that's the extent of things I don't really see enough value to warrant having a command targeting one object go looking around the system for other related state to comment upon. If one revokes usage on a schema should we inform the user of any remaining grants on contained objects? I suspect there are other useful notices to consider beyond those two. It feels like something better left to a third-party tool rather than something built into core.
