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.
SELECT * FROM fn_my_permissions('dbo.theTable', 'TABLE');
Many thanks in advance 🙂