Users catalystadmin
Properties
PropertyValue
TypeSqlUser
Login Namecatalystadmin
Default Schemadbo
Database Level Permissions
TypeAction
CONNECTGrant
SQL Script
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'catalystadmin')
CREATE LOGIN [catalystadmin] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [catalystadmin] FOR LOGIN [catalystadmin] WITH DEFAULT_SCHEMA=[dbo]
GO
GRANT CONNECT TO [catalystadmin]
Uses
Used By