![]() This provides a high level of auditing, especially during security or Data Definition Language (DDL) operations. ![]() ![]() Although you can accomplish this task in other ways, such as using the EXECUTE AS statement, using a certificate allows you to use a trace to find the original caller of the stored procedure. Signing stored procedures using a certificate is useful when you want to require permissions on the stored procedure but you do not want to explicitly grant a user those rights. To run the code in this tutorial you must have both Mixed Mode security configured and the AdventureWorks2017 database installed.
0 Comments
Leave a Reply. |