How to get a user to run a SQL query themselves

Question

How to get a user to run a SQL query themselves

G_Dubyah

Mr or Mrs. 500

Points: 584
More actions
November 3, 2011 at 6:59 am

#390751

Hi guys
I have a SQL query that the business users want to run themselves on an ad-hoc basis. How can I do this with SQL 2005 bearing in mind that I don't have access to even create a stored procedure on the databse - I am only able to execute the sql.
Any help is appreciated.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Create a front end for them. Then have somebody either give you permission or write a stored proc to get the data you want.

Allowing users direct access to sql is NOT where you want to go.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

G_Dubyah Mr or Mrs. 500 Points: 584 More actions · Answer 2

Thanks. Creating a front end is no-go. Could I create a SSIS package to run the SQL and then get the users to execute that from their command line? Would they need sql on their PC's?

seth delconte SSCertifiable Points: 6388 More actions · Answer 3

If you put SQL Server 2005 Express on their PCs, you could have them run a Windows batch file that calls a SQLCMD (or OSQL) command to run the query. Just make sure to give them very limited permissions -- create a restricted view that they can query if possible. Let me know if you want some details on creating the SQLCMD batch.

_________________________________
seth delconte
http://sqlkeys.com

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 4

you can query SQL Server from Excel

this can be used as a basic reporting system

Regards,

Iulian

G_Dubyah Mr or Mrs. 500 Points: 584 More actions · Answer 5

thanks for your input - think i'll go with the sql express, sqlcmd route.

Have a nice day 🙂