Tuesday, October 2, 2018

Change the permissions on an assembly in T-SQL.

This has this example:

ALTER ASSEMBLY ComplexNumber WITH PERMISSION_SET =
      EXTERNAL_ACCESS;

 
 

In the Object Explorer in SSMS (Microsoft SQL Server Management Studio) 2016 under a database you will find "Programmability" and under "Programmability" you will find "Assemblies" which will represent encrypted sprocs (stored procedures) and functions from a 3rd party. If a Wonderbox assembly is misbehaving, it may be wise to set it's permissions to something else and then set it back again. This seems to kick a sleeping dog awake.

No comments:

Post a Comment