Users ca_itrm_ams
(local) > mdb > Users > ca_itrm_ams
Properties
PropertyValue
TypeSqlUser
Login Nameca_itrm_ams
Default Schemaca_itrm_ams
Database Level Permissions
TypeAction
CONNECTGrant
SQL Script
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'ca_itrm_ams')
CREATE LOGIN [ca_itrm_ams] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [ca_itrm_ams] FOR LOGIN [ca_itrm_ams] WITH DEFAULT_SCHEMA=[ca_itrm_ams]
GO
GRANT CONNECT TO [ca_itrm_ams]
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved