ca_itrm

ca_itrm

Properties
Database Level Permissions
SQL Script
Uses
Used By

Property	Value
Type	SqlUser
Login Name	ca_itrm
Default Schema	ca_itrm

Database Level Permissions

Type	Action
CONNECT	Grant

SQL Script

IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'ca_itrm')
CREATE LOGIN [ca_itrm] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [ca_itrm] FOR LOGIN [ca_itrm] WITH DEFAULT_SCHEMA=[ca_itrm]
GO
GRANT CONNECT TO [ca_itrm]

Uses

ca_itrm

Used By

ca_itrm_group
db_ddladmin
db_securityadmin