Flashcards in CLR Deck (7)
What are the permissions you can set in WITH PERMISSION_SET when creating an assembly?
What is SAFE permission_set?
It is the most restrictive permission set. It cannot access the network, files, env variables or registry
What is EXTERNAL_ACCESS permission_set?
Enables assemblies to access certain external system resources such as files, networks, env variables and registry
What is UNSAFE permission_set?
Unrestricted access both within SQL instance and without. Very UNSAFE (Hence the name)
What is the code to implement a .net framework assembly?
EXTERNAL NAME Assembly.Class.Method
What is the syntax to use a DLL in SSMS (IE: CLR stored procedure)?
CREATE ASSEMBLY AssemblyName FROM N'C:\PATH\ASSEMBLY.DLL' WITH PERMISSION_SET = [SAFE,UNSAFE,EXTERNAL_ACCESS]