SQL Server/T-SQL Tutorial/CLR/ASSEMBLY

Материал из SQL эксперт
Перейти к: навигация, поиск

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>