# 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

List of Users