Assign user permission in SQL Server database

Is there anyway using query that I can assign per开发者_运维百科missions to user in a SQL Server database?

Thanks

GRANT exists even for MsSQL. http://msdn.microsoft.com/en-us/library/ms188371.aspx

You can use the T-Sql Statement GRANT

Here you can find general documentation on GRANT

While Here you can find the page specific for user privlege