SQL Server performance management is usually reactive and focused on server health. Database administrators (DBAs) respond to trouble rather than avoiding it in the first place. And visibility is largely restricted to watching the database server, rather than understanding how SQL Server directly affects application users.
Sunday, October 31, 2010
Grant Execute Permission on all SP for a database
Following method can be used to create statement to grant Execute permission on all SP for a Database.
Use DatabaseName
select 'Grant Execute on [' + name + '] to [LoginName]'
No comments:
Post a Comment