Sql – GRANT specific role ALTER access to specific table


I have tried many ways to do this with no success, but what I want to do is the following:

GRANT ALTER ON [dbo].[theTable] TO [role]

Bonus if you can also provide me some permission state before & after eg.

FROM fn_my_permissions('dbo.theTable', 'TABLE'); 

Many thanks in advance 🙂

Best Solution

GRANT ALTER ON [dbo].[theTable] TO [role]