revoking permissions

• cross

  SSCommitted

  Points: 1735

  More actions

  July 22, 2005 at 3:15 pm

  #90129

  Is there a way I can revoke about hundreds permissions all at once from the public role? I need to remove the select permission from public for every stored procedure in master. I know I could do it manually but there has got to be another way. Grateful for any suggestions! Thanks

• David Webb-CDS

  SSCoach

  Points: 17398

  More actions

  July 22, 2005 at 4:22 pm

  #576589

  Run this

  select 'revoke execute on ' + name + ' from public' from sysobjects where type = 'p'

  in the database to generate the 'revoke' commands, then run the generated commands

   

  ---

  And then again, I might be wrong ...
  David Webb