Users cohesion
Properties
PropertyValue
TypeSqlUser
Login Namecohesion
Default Schemacohesion
Database Level Permissions
TypeAction
BACKUP DATABASEGrant
BACKUP LOGGrant
CONNECTGrant
CREATE DEFAULTGrant
CREATE FUNCTIONGrant
CREATE PROCEDUREGrant
CREATE RULEGrant
CREATE TABLEGrant
CREATE VIEWGrant
SQL Script
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'cohesion')
CREATE LOGIN [cohesion] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [cohesion] FOR LOGIN [cohesion] WITH DEFAULT_SCHEMA=[cohesion]
GO
GRANT BACKUP DATABASE TO [cohesion]
GRANT BACKUP LOG TO [cohesion]
GRANT CONNECT TO [cohesion]
GRANT CREATE DEFAULT TO [cohesion]
GRANT CREATE FUNCTION TO [cohesion]
GRANT CREATE PROCEDURE TO [cohesion]
GRANT CREATE RULE TO [cohesion]
GRANT CREATE TABLE TO [cohesion]
GRANT CREATE VIEW TO [cohesion]
Uses