Advertisement
bluebunny72

Changedbowner and trustworthy

Jan 11th, 2017
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.68 KB | None | 0 0
  1.     USE BD_ILC_FORMS
  2.     EXEC sp_changedbowner sa
  3.  
  4.     USE BD_ILC_OBJECTS
  5.     EXEC sp_changedbowner sa
  6.  
  7.     USE BD_SITE1_APP
  8.     EXEC sp_changedbowner sa
  9.  
  10.     USE BD_SITE2_APP
  11.     EXEC sp_changedbowner sa
  12.  
  13.     USE master
  14.     ALTER DATABASE BD_SITE1_APP SET trustworthy ON
  15.     ALTER DATABASE BD_SITE2_APP SET trustworthy ON
  16.  
  17.     -- toggle permission set so that can run License section...
  18.     USE BD_SITE1_APP   
  19.     ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
  20.     ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
  21.  
  22.     USE BD_SITE2_APP   
  23.     ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
  24.     ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement