User: duser

Properties

Property	Value
Name	duser
Principal ID	5
Type	Sql User
Default Schema	dbo
SID	x1BC6F783107F8149913694D068FC54E0
Login	duser
Modify Date	11/22/2010 5:49:56 AM
Creation Date	11/22/2010 5:49:56 AM

Extended Properties

No extended properties defined.

Objects

Type Desc	Schema Name	Name
Asymetric Key		PacificSales29
Fulltext Stoplist		krystianStoplist

Object Level Permissions

Permissions for: dbo.ufnGetStock (SQL scalar function)

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL
DELETE
EXECUTE	dbo
INSERT
RECEIVE
REFERENCES
SELECT
TAKE OWNERSHIP	dbo
UPDATE
VIEW CHANGE TRACKING
VIEW DEFINITION	dbo

Permissions for: dbo.uspGetEmployeeManagers (SQL Stored Procedure)

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	dbo
CONTROL	dbo
DELETE
EXECUTE	dbo
INSERT
RECEIVE
REFERENCES
SELECT
TAKE OWNERSHIP	dbo
UPDATE
VIEW CHANGE TRACKING
VIEW DEFINITION	dbo

Permissions for: HumanResources.viewSynonym1 (Synonym)

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL
DELETE
EXECUTE	dbo
INSERT
RECEIVE
REFERENCES
SELECT
TAKE OWNERSHIP
UPDATE
VIEW CHANGE TRACKING
VIEW DEFINITION

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	dbo
CONTROL
DELETE
EXECUTE
INSERT	dbo
REFERENCES
SELECT
TAKE OWNERSHIP
UPDATE
VIEW CHANGE TRACKING
VIEW DEFINITION

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	dbo
CONTROL	dbo
DELETE
EXECUTE	dbo
INSERT	dbo
REFERENCES
SELECT
TAKE OWNERSHIP
UPDATE
VIEW CHANGE TRACKING
VIEW DEFINITION

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	dbo
CONTROL	dbo
EXECUTE
REFERENCES
TAKE OWNERSHIP	dbo
VIEW DEFINITION	dbo

Permissions for: HumanResources.HRResumeSchemaCollection (XML Schema Collection)

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL
EXECUTE
REFERENCES
TAKE OWNERSHIP
VIEW DEFINITION	dbo

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	dbo
CONTROL	dbo
REFERENCES	dbo
TAKE OWNERSHIP
VIEW DEFINITION

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	JohnBlack
CONTROL	JohnBlack
REFERENCES	JohnBlack
TAKE OWNERSHIP	JohnBlack
VIEW DEFINITION	JohnBlack

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL
SEND
TAKE OWNERSHIP
VIEW DEFINITION	JohnBlack

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL
TAKE OWNERSHIP	JohnBlack
VIEW DEFINITION	JohnBlack

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	JohnBlack
CONTROL
TAKE OWNERSHIP
VIEW DEFINITION

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL
REFERENCES	dbo
TAKE OWNERSHIP
VIEW DEFINITION

Permissions for:

Permission	Grantor	Grant	With Grant Option	Deny
ALTER
CONTROL	dbo
REFERENCES
TAKE OWNERSHIP
VIEW DEFINITION	dbo

Column Level Permissions

Permissions for: dbo.Phones

cusid

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES
UPDATE

Roles

Principal ID	Name
	public

SQL

Script
CREATE USER [duser] FOR LOGIN [duser] WITH DEFAULT_SCHEMA=[dbo]

See also