CODEWITHSUNDEEP
sqlsql-server-2008
Ayyappan Anbalagan
Ayyappan Anbalagan

Reputation: 11302

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

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?

Upvotes: 3

Views: 10354

Answers (2)

krock
krock

Reputation: 29619

You need to grant access to the table for your specific user/role, e.g.

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

This will allow you to change and select data within the table. To modify the table itself (add/remove columns etc.) you will want:

grant create, alter, drop on table to user

Upvotes: 2

marc_s
marc_s

Reputation: 754478

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.....

Upvotes: 3

Related Questions