CLR Integration Security in SQL Server (ADO.NET)
Microsoft SQL Server 2005 introduces the integration of the common language runtime (CLR) component of the .NET Framework. CLR integration allows you to write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, such as Microsoft Visual Basic .NET or Microsoft Visual C#.
The CLR supports a security model called code access security (CAS) for managed code. In this model, permissions are granted to assemblies based on evidence supplied by the code in metadata. SQL Server integrates the user-based security model of SQL Server with the code access-based security model of the CLR.
External Resources
For more information on CLR integration with SQL Server, see the following resources.
Resource |
Description |
|---|---|
Contains topics describing CAS in the .NET Framework. |
|
Discusses the security model for managed code executing inside of SQL Server. |
See Also
Concepts
Application Security Scenarios in SQL Server (ADO.NET)