# Role: weekly_receipts

## Properties

Property | Value
--- | ---
Name | weekly_receipts
Principal ID | 8
Owner |
Type | APPLICATION ROLE
Default Schema | dbo
Fixed Role |
SID | x010500000000000905000000C7D46BF5FFDC34478455EE378562C559
Modify Date | 12/25/2010 7:01:11 AM
Creation Date | 12/25/2010 7:01:10 AM
Principal ID | 8
Owner |
Type | APPLICATION ROLE
Default Schema | dbo
Fixed Role |
SID | x010500000000000905000000C7D46BF5FFDC34478455EE378562C559
Modify Date | 12/25/2010 7:01:11 AM
Creation Date | 12/25/2010 7:01:10 AM

## Extended Properties

Name | Value
--- | ---
MS_Description | mobi weekly_receipts

## Roles and Users with this Role

No users associated with this role.

## Object Level Permissions

#### Permissions for: HumanResources.Department (Table (user-defined))

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

#### Permissions for: HumanResources.Employee (Table (user-defined))

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

#### Permissions for: HumanResources.EmployeeDepartmentHistory (Table (user-defined))

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

#### Permissions for: HumanResources.EmployeePayHistory (Table (user-defined))

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

#### Permissions for: dbo.ExpenseQueue (Service queue)

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

#### Permissions for: dbo.Phones (Table (user-defined))

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
ALTER | dbo |  |  |
CONTROL |  |  |  |
DELETE |  |  |  |
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 |  |  |  |
DELETE |  |  |  |
EXECUTE | dbo |  |  |
INSERT | dbo |  |  |
RECEIVE |  |  |  |
REFERENCES |  |  |  |
SELECT | dbo |  |  |
TAKE OWNERSHIP |  |  |  |
UPDATE |  |  |  |
VIEW CHANGE TRACKING |  |  |  |
VIEW DEFINITION |  |  |  |

#### 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 |  |  |  |
CONTROL |  |  |  |
REFERENCES |  |  |  |
TAKE OWNERSHIP |  |  |  |
VIEW DEFINITION | dbo |  |  |

## Column Level Permissions

No explicit column permissions granted to this database principal

## SQL

Script
/* To avoid disclosure of passwords, the password is generated in script. */ declare @idx as int declare @randomPwd as nvarchar(64) declare @rnd as float select @idx = 0 select @randomPwd = N'' select @rnd = rand((@@CPU_BUSY % 100) + ((@@IDLE % 100) * 100) + (DATEPART(ss, GETDATE()) * 10000) + ((cast(DATEPART(ms, GETDATE()) as int) % 100) * 1000000)) while @idx < 64 begin select @randomPwd = @randomPwd + char((cast((@rnd * 83) as int) + 43)) select @idx = @idx + 1 select @rnd = rand() end declare @statement nvarchar(4000) select @statement = N'CREATE APPLICATION ROLE [weekly_receipts] WITH DEFAULT_SCHEMA = [dbo], ' + N'PASSWORD = N' + QUOTENAME(@randomPwd,'''') EXEC dbo.sp_executesql @statement EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'mobi weekly_receipts' , @level0type=N'USER',@level0name=N'weekly_receipts'

#### See also

List of Roles