How to give over right (table) permission in SQL Server 2008?

Question

I am using SQL Server 2008. I tried to modify the table. But it not allowing to update.

How to give UPDATE permission in SQL Server 2008?

Answer 1

Check out:

Giving and removing permissions in SQL Server

or any other decent SQL Server web site, or just google for it! There's tons of sites and books out there that will show you how to do this in great detail....

Basically, someone with the necessary permissions needs to do a

GRANT UPDATE ON (your table name) TO (your user name)

and that's about it. Of course, you may also need SELECT, INSERT and other permissions.....