SQL Server/T-SQL Tutorial/CLR/ASSEMBLY

Modifying an Assembly"s Permissions

   <source lang="sql">

ALTER ASSEMBLY ReadFiles WITH PERMISSION_SET = SAFE EXEC dbo.usp_YourProcedure</source>

Remove an Assembly from the Database

   <source lang="sql">

DROP ASSEMBLY ReadFiles</source>

Viewing Assembly Metadata

   <source lang="sql">

SELECT name, permission_set_desc FROM sys.assemblies</source>