Restricting rights to Query Analyzer only

Question

Restricting rights to Query Analyzer only

Krista McCord

Newbie

Points: 2
More actions
October 1, 2007 at 2:05 pm

#198681

We have a super user who, in SQL 2000, was given access to query analyzer to query data as needed. Since SQL 2005 combines query analyzer with other tools, we need to know 1. if it is possible to restrict this user to only access query analyzer when she logs in and 2. if it is possible, how exactly would we do this?

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

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

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

Nope - a login is a login. MS SQL does not allow you to restrict a loging to a specific application, and certainly not by default to part of Management Studio.

You could just not install Management Studio on her PC - Query Analyzer will still work just fine until you can find a replacement for doing this.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 2

No way to restrict things, but some things, like the Object Browser do not work against 2005.

I'd do as Michael suggested and leave him/her with QA.

If you've got programmers, use some controls and make a simple query window, then have it execute an application role when it connects. That will limit things, but only if you have no other rights for this user.

If they have rights, they can use Access, Excel, anything to connect.

Lowell SSC Guru Points: 323504 More actions · Answer 3

you can restrict access to executables and such via NT permissions and Active directory.

Once connected, unless you restricted his access to some objects, he's pretty much got access right?

if he can fidle with a table cia QA, he could fiddle with it with a vb script or any application that gives him a similar interface.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Krista McCord Newbie Points: 2 More actions · Answer 4

Thanks for all your help. I was able to get what she needed from your statements.