Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Dallas
    Posts
    1

    Unanswered: How to Disable Connect Option in Query Analyzer

    Does anyone know how to diable the File => Connect option in Query Analyzer?
    Thanks

    Clarification:
    The situation is that I have several users on an application that controls their access to the DB. The user ID has full rights to the DB but the application stops them from making changes to data. Now I have a user that needs to be able to create and run SELECT statements in a “Query Analyser” type of environment. I can publish a Query Analyser session with locked credentials using Citrix, but I don’t want him to be able to use the File => Connect option to reconnect with one of the application Ids thus giving him full rights in an open environment.
    Any ideas?
    Thanks
    Last edited by greerda; 02-29-04 at 11:33.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    I don't think its possible in SQL, but for the audit purpose you can turn on AUDITing in SQL or use third party tools to catch the culprit.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •