Toad World® Forums

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


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?


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?