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>