restricting login in query analyzer

  • I have two logins, one has full access, and one is limited.

    In query analyzer, we are required username and password, right. is there anyway I can block the full access login to be used? But i can't delete my full access login account because it is being used by our systems. I just want my programmers to use the limited account in using query analyzer.

  • Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769122-5-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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