Read Only Query Tool - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Read Only Query Tool

Author

Topic

dotinf
Starting Member

6 Posts

Posted - 2010-02-25 : 19:52:15

Hi guys,

I am looking for a free sql query tool which is read only, i.e. only does Select statements. Any advice on this.

Cheers

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-02-25 : 20:18:43

Well just provide db_datareader role to a specific user and have your customer use that in whatever query tool they want to use.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

dotinf
Starting Member

6 Posts

Posted - 2010-02-25 : 21:37:39

Thanks for that tkizer. I'm going to stay away from the issue at the moment as I need to investigate current user roles in the database. They'll just have to do without for a while.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources