SQL Server/T-SQL Tutorial/CLR/ASSEMBLY

Modifying an Assembly"s Permissions

ALTER ASSEMBLY ReadFiles
WITH PERMISSION_SET = SAFE
EXEC dbo.usp_YourProcedure

Remove an Assembly from the Database

DROP ASSEMBLY ReadFiles

Viewing Assembly Metadata

SELECT name, permission_set_desc
FROM sys.assemblies