bluebunny72 icon

Changedbowner and trustworthy

bluebunny72 | PRO | 01/11/17 08:27:27 PM UTC | 0 ⭐ | 527 👁️ | Never ⏰ | []
SQL |

680 B

|

None

|

0 👍

/

0 👎

    USE BD_ILC_FORMS
    EXEC sp_changedbowner sa 
 
    USE BD_ILC_OBJECTS
    EXEC sp_changedbowner sa 
 
    USE BD_SITE1_APP 
    EXEC sp_changedbowner sa 
 
    USE BD_SITE2_APP 
    EXEC sp_changedbowner sa 
 
    USE master
    ALTER DATABASE BD_SITE1_APP SET trustworthy ON
    ALTER DATABASE BD_SITE2_APP SET trustworthy ON
 
    -- toggle permission set so that can run License section...
    USE BD_SITE1_APP    
    ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
    ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS
 
    USE BD_SITE2_APP    
    ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = SAFE
    ALTER ASSEMBLY [ESDatabaseObjects] WITH PERMISSION_SET = EXTERNAL_ACCESS

Comments