SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];
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
About satya
SQL Server MVP.
SQL Master, Speaker & SQL Server helper.
16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities :
Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above.
Active member of most of the SQL Server community forums.