To perform both. it was a client request.
Bad idea. In all ways. Users should not be directly managing tables. Ever. People without database expertise are going to mess things up in one heck of a hurry. Also, you'd have to spend as much effort or more, building such a web application. There are no built-in web apps for managing the tables. And for darn good reason. Best you could do "out of the box" is to prepare SSRS reports for the users and give them the links to the reports. Those are served up via the web, and you can control who has access to which report folders using AD.
+1 million...
What you're trying to do is create an easy to use SQL Injection interface.