SQL command line to create ca_itrm user

book

Article ID: 35788

calendar_today

Updated On:

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: