bluebunny72 icon

Toggle Assembly Permissions

bluebunny72 | PRO | 08/30/16 05:58:17 PM UTC | 0 ⭐ | 703 👁️ | Never ⏰ | []
T-SQL |

1.56 KB

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
-- some of these are not being toggled, so not sure if reloading permission set or not
 
USE XX_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