Monday, July 3, 2006

Stored procedure permissions script

select 'Grant EXEC on ' + name + ' to MyUser' 
  from sysobjects 
 where type = 'P' 

No comments: