DB__ROOT required to revoke object and column privileges granted by other users

[Cliff Gray]

DBAs cannot manage object and column grants performed by other users. A component privilege is needed to allow an administrator to manage granted privileges at the object and column level.

E.g.

REVOKE SELECT ON Table1 FROM User1 GRANTED BY User2;

There needs to be a method for a user/role to be granted the authority to perform this operation. Currently restricted to DB__ROOT.

[Cliff Gray (cliff-gray)]

Fix in delivery 1742.