SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Sprocs permissions - how do I check??
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Lorna70
Starting Member

United Kingdom
19 Posts

Posted - 01/07/2011 :  06:29:53  Show Profile  Reply with Quote
Hi
I had some sprocs on my DB set up to enable SQL Express (2008) backup scheduling as per:
http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express
I then ran a the following T-SQL to Grant execute permissions to all stored procedures in this DB:
USE DBS_New
GRANT EXECUTE TO New_DBS_user
Now the scheduling as stopped working so I can only assume it's a permissions problem as it it was working fine before I ran this T-SQL. What do I have to do now to get them to run again?? I'm not sure which user they were running under before - how do I find this out?

Lorna, Web developer, Scotland
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000