Users ITASM\AIRestricted
(local) > mdb > Users > ITASM\AIRestricted
Properties
PropertyValue
TypeWindowsUser
Login NameITASM\AIRestricted
Database Level Permissions
TypeAction
CONNECTGrant
SQL Script
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'ITASM\AIRestricted')
CREATE LOGIN [ITASM\AIRestricted] FROM WINDOWS
GO
CREATE USER [ITASM\AIRestricted] FOR LOGIN [ITASM\AIRestricted]
GO
GRANT CONNECT TO [ITASM\AIRestricted]
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved