Login: projectenvision\JohnBlack

Properties

Property	Value
Login Name	projectenvision\JohnBlack
Principal ID	269
Login Type	WINDOWS LOGIN
Enabled
SID	x01050000000000051500000025B2C65A6DE3BF7F151D61F351040000
Default Database	master
Default Language	us_english
Default language friendly name	English
Enforce Password Policy
Enforce Password Expiration
Permission to connect to database engine
Mapped to certificate
Mapped to asymmetric key
System Object
Last Modify Time	10/12/2011 2:40:42 AM
Create Time	12/19/2010 6:45:02 PM

Login mapped to credentials

Login is not mapped to any credential

Login mapped to database users

Database Name	Username	Type
AdventureWorks2008	JohnBlack	WINDOWS USER

Server Roles for that login

No server roles for this login.

Login Permissions on the server

No Server Permissions defined for that login

SQL

Script
CREATE LOGIN [projectenvision\JohnBlack] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english] DENY CONNECT SQL TO [projectenvision\JohnBlack]

See also