Users NT AUTHORITY\SYSTEM
(local) > msdb > Users > NT AUTHORITY\SYSTEM
Properties
PropertyValue
TypeWindowsUser
Login NameNT AUTHORITY\SYSTEM
Default Schemadbo
Database Level Permissions
TypeAction
CONNECTGrant
SQL Script
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'NT AUTHORITY\SYSTEM')
CREATE LOGIN [NT AUTHORITY\SYSTEM] FROM WINDOWS
GO
CREATE USER [NT AUTHORITY\SYSTEM] FOR LOGIN [NT AUTHORITY\SYSTEM] WITH DEFAULT_SCHEMA=[dbo]
GO
GRANT CONNECT TO [NT AUTHORITY\SYSTEM]
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved