Home Forums SQL Server 2008 Security (SS2K8) Ownership chaining from SP to table RE: Ownership chaining from SP to table

  • November 16, 2015 at 6:54 am

    #1839945

    Erland Sommarskog (11/16/2015)

    You can sign the procedure with a certificate. From the certificate you create a user which you grant the permissions needed.

    I describe this technique in detail in an article on my web site:

    Granting Permissions through Stored Procedures.

    Great, I'll have a look at that. Thank you.