roles icon Role: weekly_receipts

Properties

Property Value
Name weekly_receipts
Principal ID 8
Owner
Type APPLICATION ROLE
Default Schema dbo
Fixed Role false
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 false
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 true
TAKE OWNERSHIP
UPDATE dbo true
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 true
TAKE OWNERSHIP
UPDATE dbo true
VIEW CHANGE TRACKING
VIEW DEFINITION

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

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

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

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

Permissions for:

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

Permissions for:

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

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