Sql – GRANT specific role ALTER access to specific table

sqlsql-server-2005

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 🙂

Best Solution

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