User Properties

Name	Value
Name	JamesC
Login
Roles	public

Objects

Does not own any objects

Permissions

No direct permissions defined (N.B. Permissions may be inherited from roles

SQL

if not exists (select * from dbo.sysusers where name = N'JamesC' and uid < 16382)
	EXEC sp_grantdbaccess N'JamesC'
GO