SQL read/Write Permissions from website

Question

I've got a website that pulls data from a sql database and displays it in Grid format, now i need to add permissions so certain users can edit/update information to the database from the grid on the website.

Any ideas are welcome,

Thanks

Answer 1

You Can Control the saving part via some rights settings through C#(server side coding)

Or you control them in the client side itself using javascript. By disabling the save buttons.

Please note that server side validation has to be done if client side validation is done for security concerns