# 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

List of Users