Stored Procedure

“execute as”

Podemos determinar como será executado o código dentro do SP:

Opções do Execute As:

• Caller — execute with the owner permissions of the user executing the stored procedure.

• Self — execute with the permission of the user who created or altered the stored procedure.

• Owner — execute with the permissions of the owner of the stored procedure.

• <user> — execute with the permission of the specific named user.