User: JohnBlack

Properties

Property	Value
Name	JohnBlack
Principal ID	6
Type	Windows User
Default Schema	dbo
SID	x01050000000000051500000025B2C65A6DE3BF7F151D61F351040000
Login	projectenvision\JohnBlack
Modify Date	12/19/2010 6:48:40 PM
Creation Date	12/19/2010 6:48:40 PM

Extended Properties

Name	Value
MS_Description	Testowy user bazy danych

Objects

Type Desc	Schema Name	Name
Contract		//Adventure-Works.com/Expenses/ExpenseSubmission
Full Text Catalog		JohnCatalog
Fulltext Stoplist		kstoplist
Message Type		//Adventure-Works.com/Expenses/ExpenseReimbursed
Remote Service Binding		APBinding
Remote Service Binding		mobiBinding
Role		KrystianRole
Routes		ExpenseRoute
Service		//Adventure-Works.com/Expenses
User Defined Data Type	dbo	MyTestType
USER_TABLE	dbo	towner
VIEW	dbo	KrystianProductView
XML Schema Collection	dbo	KrystianSchemaProducts

Object Level Permissions

Permissions for: Production.ProductInventory (Table (user-defined))

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

Permissions for: dbo.ufnGetProductDealerPrice (SQL scalar function)

Permission	Grantor	Grant	With Grant Option	Deny
ALTER	dbo
CONTROL	dbo
DELETE
EXECUTE	dbo
INSERT
RECEIVE
REFERENCES	dbo
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: dbo.ExpenseQueue (Service queue)

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

Permissions for: HumanResources.Shift (Table (user-defined))

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

Permissions for: HumanResources.HRResumeSchemaCollection (XML Schema Collection)

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

Permissions for:

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

Permissions for:

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

Permissions for:

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

Permissions for:

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

Column Level Permissions

Permissions for: HumanResources.vEmployee

City

Permission	Grantor	Grant	With Grant	Deny
SELECT
REFERENCES
UPDATE	dbo

Title

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES
UPDATE

Permissions for: Person.EmailAddress

EmailAddress

Permission	Grantor	Grant	With Grant	Deny
SELECT
REFERENCES
UPDATE	dbo

Permissions for: Production.Product

Size

Permission	Grantor	Grant	With Grant	Deny
SELECT
REFERENCES
UPDATE	dbo

Permissions for: Production.ProductDescription

Description

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES
UPDATE

Roles

Principal ID	Name
16386	db_securityadmin
16391	db_datawriter
	public

SQL

Script
CREATE USER [JohnBlack] FOR LOGIN [projectenvision\JohnBlack] WITH DEFAULT_SCHEMA=[dbo] sys.sp_addrolemember @rolename = N'db_securityadmin', @membername = N'JohnBlack' sys.sp_addrolemember @rolename = N'db_datawriter', @membername = N'JohnBlack' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Testowy user bazy danych' , @level0type=N'USER',@level0name=N'JohnBlack'

See also