T-SQL How to grant role to user
Solution 1:
Because BOL shows sp_addrolemember has been deprecated, if you are using SQL Server 2012 you may want to use:
ALTER ROLE <role_name> ADD MEMBER <user_name>
Solution 2:
EXEC sp_addrolemember 'db_owner', 'JohnJacobs'