bluebunny72 icon

Assemblies Permissions

bluebunny72 | PRO | 09/21/15 02:57:32 PM UTC | 0 ⭐ | 691 👁️ | Never ⏰ | []
T-SQL |

1.56 KB

|

None

|

0 👍

/

0 👎

-- some of these are not being toggled, so not sure if reloading permission set or not
 
USE T1_MAIN_APP 
 
ALTER ASSEMBLY [ESActionParmsSqlClr] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [ESActionParmsSqlClr] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [EventHandlerSQLClr] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [EventHandlerSQLClr] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [GoldParserSqlClr] WITH PERMISSION_SET = SAFE
    
ALTER ASSEMBLY [IDOBaseSqlClrExternal] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [IDOBaseSqlClrExternal] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [MGFormStringsSqlClr] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [MGFormStringsSqlClr] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [MGSharedSqlClr] WITH PERMISSION_SET = SAFE
 
ALTER ASSEMBLY [MGSharedSqlClrExternal] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [MGSharedSqlClrExternal] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [MGSharedSqlClrUnsafe] WITH PERMISSION_SET = UNSAFE -- can't be SAFE
 
ALTER ASSEMBLY [PricingEngineCLR] WITH PERMISSION_SET = UNSAFE -- can't be SAFE 
 
ALTER ASSEMBLY [Replication] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [Replication] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
ALTER ASSEMBLY [SSSTraceAppProcedures] WITH PERMISSION_SET = UNSAFE -- can't be SAFE
 
ALTER ASSEMBLY [TimeZone] WITH PERMISSION_SET = SAFE
ALTER ASSEMBLY [TimeZone] WITH PERMISSION_SET = EXTERNAL_ACCESS

Comments