SQL Hardening

• hydbadrose

  SSCarpal Tunnel

  Points: 4164

  More actions

  April 22, 2010 at 7:36 pm

  #156897

  Need help-We just finished the sql hardening such as set of granting and revoking permissions. After that we are unable to drop a trigger. The user used to drop a trigger was db-owner. Please suggest how to fix this issue?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 22, 2010 at 10:03 pm

  #1156587

  Hope you have an account with sysadmin priviledges available, else wise, you may have some troubles.