New optional clause WITH CALLER PRIVILEGES will point engine to use privileges of caller object (stored procedure or trigger) in addition to user's priviliges. The same as if dynamic statement was part of caller object.
It works for EXECUTE STATEMENT against current database only, i.e. if ON EXTERNAL DATA SOURCE clause is omitted.
Vlad Khorsun added a comment - 08/Jun/08 04:49 PM New optional clause WITH CALLER PRIVILEGES will point engine to use privileges of caller object (stored procedure or trigger) in addition to user's priviliges. The same as if dynamic statement was part of caller object.
It works for EXECUTE STATEMENT against current database only, i.e. if ON EXTERNAL DATA SOURCE clause is omitted.
Improvement
Resolved
Major
Allow EXECUTE STATEMENT to inherit access privileges of caller stored procedure or trigger
It works for EXECUTE STATEMENT against current database only, i.e. if ON EXTERNAL DATA SOURCE clause is omitted.