EXECUTE AS USER = 'user_1';

CREATE LOGIN        test@test
    WITH PASSWORD = '123456'
    , DEFAULT_DATABASE = my_database
    , CHECK_POLICY = OFF
    , CHECK_EXPIRATION = OFF;

CREATE USER         test@test
    FOR LOGIN       test@test;

CREATE PROCEDURE        users.usp_newUser
                        (
                            @email          VARCHAR(254)
                            , @firstName    VARCHAR(35)
                            , @lastName     VARCHAR(35)
                            , @password     CHAR(88)
                            , @salt         VARCHAR(MAX)
                            , @isSuccess    BIT OUT
                        )
AS
BEGIN

    SET                 @isSuccess = 1;

    SET NOCOUNT ON;

    EXECUTE AS USER = 'user_1';

    EXECUTE             users.usp_newUserForPrivilege
                            @email
                            , @firstName
                            , @lastName
                            , @password
                            , @salt
                            , @isSuccess;

    RETURN;

END;
GO