Reputation: 1501
Is there anyway using query that I can assign permissions to user in a SQL Server database?
Thanks
Upvotes: 0
Views: 1430
Reputation: 8508
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
Upvotes: 2
Reputation: 5462
GRANT exists even for MsSQL. http://msdn.microsoft.com/en-us/library/ms188371.aspx
Upvotes: 4