Table of Contents

Management

Grant

Reference

GRANT CONTROL SERVER TO [LoginName];
GRANT CONNECT TO [LoginName];
GRANT ALTER ON [dbo].[theTable] TO [role] 

View

To view the permissions granted to you on the object, use the fn_my_permissions function like this:

SELECT *
FROM sys.fn_my_permissions('object', 'OBJECT')
;