Advertisement
bluebunny72

Assemblies Permissions

Sep 21st, 2015
459
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.56 KB | None | 0 0
  1. -- some of these are not being toggled, so not sure if reloading permission set or not
  2.  
  3. USE T1_MAIN_APP
  4.  
  5. ALTER ASSEMBLY [ESActionParmsSqlClr] WITH PERMISSION_SET = SAFE
  6. ALTER ASSEMBLY [ESActionParmsSqlClr] WITH PERMISSION_SET = EXTERNAL_ACCESS
  7.  
  8. ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
  9. ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
  10.  
  11. ALTER ASSEMBLY [EventHandlerSQLClr] WITH PERMISSION_SET = SAFE
  12. ALTER ASSEMBLY [EventHandlerSQLClr] WITH PERMISSION_SET = EXTERNAL_ACCESS
  13.  
  14. ALTER ASSEMBLY [GoldParserSqlClr] WITH PERMISSION_SET = SAFE
  15.    
  16. ALTER ASSEMBLY [IDOBaseSqlClrExternal] WITH PERMISSION_SET = SAFE
  17. ALTER ASSEMBLY [IDOBaseSqlClrExternal] WITH PERMISSION_SET = EXTERNAL_ACCESS
  18.  
  19. ALTER ASSEMBLY [MGFormStringsSqlClr] WITH PERMISSION_SET = SAFE
  20. ALTER ASSEMBLY [MGFormStringsSqlClr] WITH PERMISSION_SET = EXTERNAL_ACCESS
  21.  
  22. ALTER ASSEMBLY [MGSharedSqlClr] WITH PERMISSION_SET = SAFE
  23.  
  24. ALTER ASSEMBLY [MGSharedSqlClrExternal] WITH PERMISSION_SET = SAFE
  25. ALTER ASSEMBLY [MGSharedSqlClrExternal] WITH PERMISSION_SET = EXTERNAL_ACCESS
  26.  
  27. ALTER ASSEMBLY [MGSharedSqlClrUnsafe] WITH PERMISSION_SET = UNSAFE -- can't be SAFE
  28.  
  29. ALTER ASSEMBLY [PricingEngineCLR] WITH PERMISSION_SET = UNSAFE -- can't be SAFE
  30.  
  31. ALTER ASSEMBLY [Replication] WITH PERMISSION_SET = SAFE
  32. ALTER ASSEMBLY [Replication] WITH PERMISSION_SET = EXTERNAL_ACCESS
  33.  
  34. ALTER ASSEMBLY [SSSTraceAppProcedures] WITH PERMISSION_SET = UNSAFE -- can't be SAFE
  35.  
  36. ALTER ASSEMBLY [TimeZone] WITH PERMISSION_SET = SAFE
  37. ALTER ASSEMBLY [TimeZone] WITH PERMISSION_SET = EXTERNAL_ACCESS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement