SQL Server Performance

Dynamic SQL & Digital Signature procedures with SQL 2005

Discussion in 'SQL Server Knowledge Sharing Network (SqlServer-qa' started by satya, Aug 15, 2007.

  1. satya Moderator

    Dynamic SQL (DSQL) is very powerful and sometimes it is quite dangerous too in terms of security, within SQL 2005 the new feature called digitally signing module within DSQL. Before that it is important to learn and understand any such feature in order to use it properly. So by using the digital signature as a mechanism to extend permissions affects any operation on the body of the signed module, including dynamic SQL executed in it. So for further information on these methods refer to the following articles:Module Signing
    Understanding Execution Context
    procedure signing demo
    how to use counter signatures
    ImprovingDataSecurity

Share This Page