Role: KrystianRole

Properties

Property	Value
Name	KrystianRole
Principal ID	7
Owner	JohnBlack
Type	DATABASE ROLE
Default Schema
Fixed Role
SID	x010500000000000904000000DFF29F5C2A12184886CD01E894A3DE27
Modify Date	1/2/2011 5:11:21 AM
Creation Date	12/24/2010 5:49:42 AM
Principal ID	7
Owner	JohnBlack
Type	DATABASE ROLE
Default Schema
Fixed Role
SID	x010500000000000904000000DFF29F5C2A12184886CD01E894A3DE27
Modify Date	1/2/2011 5:11:21 AM
Creation Date	12/24/2010 5:49:42 AM

Extended Properties

Name	Value
MS_Description	mobi KrysanRole

Roles and Users with this Role

Principal ID	Username
9	cart

Object Level Permissions

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

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

Permissions for: HumanResources.vEmployee (View)

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

Permissions for: HumanResources.viewSynonym1 (Synonym)

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

Permissions for: HumanResources.vJobCandidate (View)

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

Permissions for:

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

Permissions for:

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

Column Level Permissions

Permissions for: HumanResources.Employee

JobTitle

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES	dbo
UPDATE

MaritalStatus

Permission	Grantor	Grant	With Grant	Deny
SELECT
REFERENCES
UPDATE	dbo

Permissions for: Production.Product

Name

Permission	Grantor	Grant	With Grant	Deny
SELECT	dbo
REFERENCES
UPDATE

SQL

Script
CREATE ROLE [KrystianRole] AUTHORIZATION [JohnBlack] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi KrysanRole' , @level0type=N'USER',@level0name=N'KrystianRole'

See also