Is there a way for users to modify column/table comments without owning the object?

mrosman
New Contributor

From my understanding, a user needs to own the object in order to alter the comments of columns/tables. A user would also need ALTER TABLE permissions in order to make the change. Is there a way to permit a user to change comments without giving them full alter table permissions?

Ideally there would be a permission similar to "APPLY TAG" that could be used to modify such metadata without actually altering the table.

 

Thanks!