# 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

List of Roles