REVOKE CONNECT FOR DB USER

• Sam Greene

  SSCertifiable

  Points: 5252

  More actions

  May 7, 2008 at 9:42 am

  #71944

  Hi,

  I'm trying to run this command on a sql 2000 database, but perhaps it's not possible. REVOKE CONNECT FROM test_user is what I was trying.

  Thanks

  Sam

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 7, 2008 at 9:52 am

  #811913

  I don't think this works in SQL Server 2000. In 2005 I believe it would be DENY CONNECT.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question