Home > Forum > Database > CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER

CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER
0

MVP

Hi Raluca,

I doubt that WEBCON is deploying any assemblies to the SQL server which would be used in any sql statements.

This also didn't return any rows on my server.
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-clr-loaded-assemblies-transact-sql?view=azuresqldb-current
SELECT a.name, a.assembly_id, a.permission_set_desc, a.is_visible, a.create_date, l.load_time
FROM sys.dm_clr_loaded_assemblies AS l
INNER JOIN sys.assemblies AS a
ON l.assembly_id = a.assembly_id;

Nevertheless, the support will be the only source to give you a reliable answer.

Best regards,
Daniel