ServiceDesk

ServiceDesk

Properties
Database Level Permissions
SQL Script
Uses
Used By

Property	Value
Type	SqlUser
Login Name	ServiceDesk
Default Schema	dbo

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=[dbo]
GO
GRANT CONNECT TO [ServiceDesk]

Uses

Used By

db_datareader
db_datawriter
db_owner