User A owns all of our tables and has access to all of our schemas
User B needs full access including Drop and Alter permissions to some of those tables and schemas but not all of them.
As is well documented, Drops and Alters are not possible because User B does not own the tables.
UserB => DROP TABLE userATable; ERROR: must be owner of relation test
The recommendation in this case seems to be to make Role B a member of Role A.
grant UserB to UserA;
But we cannot do this because then UserB will have access to schemas for which it should not. What are recommended strategies to handle this?