Toad World® Forums

Alter Stored Procedure adds "WITH EXEC AS ..." to the script


#1

When I create or edit a stored procedure, I get the statement “WITH EXEC AS USER” added in the script.

How can I configure Toad to stop adding this statement in the sprocs?


#2

Hi,
It is controlled by ‘User’ option on the Options tab of the dialog. Caller is the SS default value.
Why do you want this to be removed from the script?