June 21, 2007 at 12:41 pm
I having this wierd problem, where I'm getting different permissions when I execute T-SQL in Query Analyzer vs when I put that exact same code into a Stored Procedure and then execute the Stored Procedure from Query Analyzer. My code is creating an OLE object to execute a DTS package, and uses some sprocs built into the "master" database.
When I execute the code straight in Query Analyzer, it works fine, but when I put the same exact code into a sproc and execute the sproc from QA, I get this error:
Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 5
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.
Any idea why this is happening? I did a SELECT suser_sname() from both QA and from the Sproc, and they both returned the same username. The owner of the sproc is dbo.
June 21, 2007 at 2:03 pm
Same user account used for both runs?
June 21, 2007 at 3:42 pm
Yup, done in the same instance of QA, just did a new window.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply