Export (0) Print
Expand All

CLR Integration Security in SQL Server

Microsoft SQL Server provides 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.

For more information on CLR integration with SQL Server, see the following resources.

Resource

Description

Code Access Security

Contains topics describing CAS in the .NET Framework.

CLR Integration Security

Discusses the security model for managed code executing inside of SQL Server.

Show:
© 2015 Microsoft