Hi Hank,
I’m ok to see such reports on the community. Nothing critical for Toad I suppose.
Regarding you message, It always worked in this way as I see to previous versions. Not sure it is a bug though.
regards,
Alexander Maximov
From: Hank Freeman(MSN) [mailto:hfreeman@msn.com]
Sent: Friday, April 27, 2012 1:54 AM
To: Valentin Baev; Alexander Maximov
Subject: Toad-ss 5.7.0.452 - Create User Like - Not picking up Grant View on Schema Information
When running the Wizard Create User Like ConvDev2 and new ID = 'ConvDev2_HF.
The wizard doesn’t pick up the schema permission syntax that you see below.
Please advise if you want these type of security issues published on the forum or sent in directly.
USE[CMA_AIT];-- updated 25-April-2012.
GO
CREATEUSER[ConvDev2]FORLOGIN[ConvDev2];
GO
EXEC sys.sp_addrolemember @rolename=N'db_datareader', @membername=N'ConvDev2';
EXEC sys.sp_droprolemember @rolename=N'db_datawriter', @membername=N'ConvDev2';
GRANT VIEW DEFINITIONONschema::[dbo] TO[ConvDev2];
GrantExecuteonSchema::[dbo]to[ConvDev2];
USE[CMA_AIT];
GO
CREATEUSER[ConvDev2_HF]FORLOGIN[ConvDev2_HF];
GO
EXEC sys.sp_addrolemember @rolename=N'db_datareader', @membername=N'ConvDev2_HF';
EXEC sys.sp_droprolemember @rolename=N'db_datawriter', @membername=N'ConvDev2_HF';
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
