SQL command line to create ca_itrm user

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

Question: 

What SQL command do you run to create the ca_itrm user account ? 

 

Answer:

Execute the below statements to create ca_itrm user

IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'ca_itrm')

CREATE LOGIN [ca_itrm] WITH PASSWORD = 'NOT_changedR11'

GO

CREATE USER [ca_itrm] FOR LOGIN [ca_itrm] WITH DEFAULT_SCHEMA=[ca_itrm]

GO

GRANT CONNECT TO [ca_itrm]

 

Note: This is just another method of creating ca_itrm user. 

 

 

 

 

Environment

Release: UASIT.99000-12.9-Asset Intelligence
Component: