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