O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Security

Depending on the deployment method, you have numerous ways to specify which security level to grant a CLR assembly. All of them demand that you specify one of three permission sets:

  • Safe. Assembly can perform local data access and computational tasks only.

  • External_Access. Assembly can perform local data access and computational tasks and also access the network, the file system, the registry, and environment variables. Although External_Access is less restrictive than Safe, it still safeguards server stability.

  • Unsafe. Assembly has unrestricted permissions and can even call unmanaged code. This setting can significantly compromise SQL Server security; only members of the sysadmin role can create (load) unsafe assemblies. Also note that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required