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.