Monday, 3 July 2006

Stored procedure permissions script 

select 'Grant EXEC on ' + name + ' to MyUser' 
  from sysobjects 
 where type = 'P'
By -
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)