ServiceDesk

ServiceDesk

Properties
Database Level Permissions
SQL Script
Uses
Used By

Property	Value
Type	SqlUser
Login Name	ServiceDesk
Default Schema	ServiceDesk

Database Level Permissions

Type	Action
CONNECT	Grant

SQL Script

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

Uses

ServiceDesk

Used By

ams_group
amsgroup
db_ddladmin
db_securityadmin
regadmin
service_desk_admin_group
service_desk_d_painter_group
service_desk_ro_group
workflow_admin_group