We could easily grant execute permission to a user on all stored procedures on a database as below. USE GO GRANT EXECUTE TO GO But…
Did you come across any situation where you wanted to make sure that the password you set for a SQL account is what you really…
SOLUTION: 1) Go to MSDB– Security –Users — UserName — User Name Properties — Assigned the ‘TargetServerRole’ in msdb 2) Run the query select pr.name,…
You must be logged in to post a comment.