Toad World® Forums

Alter User error.


#1

Hi,
using alter user I changed role membership as follow:

Toad generated script:

USE [master];
GO
ALTER LOGIN [ASTER\MMotyl] WITH
DEFAULT_DATABASE = [Dev];
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’bulkadmin’;
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’dbcreator’;
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’diskadmin’;
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’processadmin’;
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’securityadmin’;
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’serveradmin’;
GO
EXEC sys.sp_addsrvrolemember @loginame = N’ASTER\MMotyl’, @rolename =
N’setupadmin’;
GO
USE [Dev];
GO
EXEC sys.sp_addrolemember @rolename = N’db_ddladmin’, @membername = N’dbo’;
EXEC sys.sp_addrolemember @rolename = N’db_securityadmin’, @membername = N’dbo’;

GO

Red part fails [on sql 2008]

severity: critical!

Butter

int_1.jpeg
int_1.jpeg


#2

Thanks for reporting!

Going to be fixed in the next beta.

Regards,
Valentine