How to pass the correct (table) permission in SQL Server 2008?

Question

I am using SQL Server 2008. I tried to modify the table. But this does not allow updating.

How to grant UPDATE permission in SQL Server 2008?

Answer 1

Departure:

Granting and Removing Permissions in SQL Server

or any other worthy SQL Server website or just google for it! There are many sites and books that will show you how to do this in great detail ....

In principle, someone with the necessary permissions needs to be done

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

and what about it. Of course, you may also need SELECT, INSERT, and other permissions .....

Answer 2

/, .

grant select, insert, update, delete on table to user

. (/ ..), :

grant create, alter, drop on table to user