Stored Procedure Replication and the execute as Clause

Ensure support for stored procedure replication when you create stored procedures with the execute as {owner | caller} clause of the Adaptive Server create procedure command.

See Executing a Procedure with execute as owner or execute as caller in the Adaptive Server Enterprise Security Administration Guide.

If you use the execute as {owner | caller} clause to create procedures, the identity of the caller at the primary database is not always preserved at the replicate database. If the identities differ, stored procedure replication may fail.

See Stored Procedure Replication and the execute as Clause in the Replication Server Administration Guide Volume 1 to ensure successful replication of stored procedures.