ODServer

ODServer

Properties
Database Level Permissions
SQL Script
Uses
Used By

Property	Value
Type	SqlUser
Login Name	ODServer
Default Schema	ODServer

Database Level Permissions

Type	Action
CONNECT	Grant

SQL Script

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

Uses

ODServer

Used By

db_datareader
db_datawriter
db_owner