Setting a table for write abilities

[rtdvoip]

What is the quickest procedure for setting a table
to be read-wite?

thanks in advance,
rtdvoip

 

[mrdenny]

Tables are always read-write. The users access to the table is what needs to be changed. To grant read access use "grant select on TableName to UserName". Replace select with insert or update or delete depending on what writes you need to grant.

You can also do more than one at a time "grant select, update, insert on TableName to UserName".

Also check out GRANT on BOL.

Denny Cherry