Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2005-12-05 : 08:50:28
|
| Greetings from Tahiti,One of my users wants to query a couple of tables.I need a web based tool that will allow one of my users to query on some tables. All the existing tools out there appear to offer a wealth of administration bells and whistles. I just want a simple query tool that he can access via the web and not have to install on his machine.Any suggestions?Thanks,Drew |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-12-05 : 09:04:22
|
| 1. There is no such thing as EASY when it comes to opening up a database via the WEB. The SIMPLER the tool is, then the more concern that there should be for what queries will actually be allowed. Meaning SELECT * from Table1, can be modified to DELETE Table1 very quickly. Or where your application may enforce some limitations on the number of rows it will retrieve, the Query from the WEB can become SELECT * instead of SELECT TOP 1000 really easily as well. Applications can show the end user which tables they want the user to see, a generic Query window will allow the user to access any table (including system tables) that they aren't restricted from seeing in SQL Server.2. However, do they want a query design tool via the web where they can see the objects available, or are they simply looking for a Text box that they can type a query into, and then have the results returned? How do they want to input the server/database/user/password parameters? |
 |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2005-12-05 : 09:13:38
|
quote:
Meaning SELECT * from Table1, can be modified to DELETE Table1 very quickly. Or where your application may enforce some limitations on the number of rows it will retrieve, the Query from the WEB can become SELECT * instead of SELECT TOP 1000 really easily as well.
Thanks for replying.There is no limit on what they can Select. My intention was to create a SQL Server login that would restrict their access to only Select. If they tried to update/delete it would error. quote:
However, do they want a query design tool via the web where they can see the objects available, or are they simply looking for a Text box that they can type a query into, and then have the results returned? How do they want to input the server/database/user/password parameters?
Preferably the former so they know what tables are available to query from, but the latter will suffice if that's a hassle to set up.Someone has asked to see all Sales from blahdy blah date. I don't mind setting up a view that restricts him to certain tables, but he will need to see what columns has can play with really.Drew |
|
|
|
|
|
|
|
|
Simple web based Query Analyser needed