Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: store proc EXEC AS

    Use "with execute as 'dbo' "

    ------------------------------------------------------------------------------------------------------------------

    -- Prep

    ------------------------------------------------------------------------------------------------------------------

    -- Create test users and test db

    USE [master]

    GO

    CREATE LOGIN [testAdmin] WITH PASSWORD=N'Dork', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

    GO

    CREATE LOGIN [testUser] WITH PASSWORD=N'Dork', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

    GO

    CREATE DATABASE [testDB]...

Viewing post 1 (of 1 total)