Assign user permission in SQL Server database

Question

Hi,

Is there anyway using query that I can assign permissions to user in a SQL Server database?

Thanks

Answer 1

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

Answer 2

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