Role: [AdventureWorks2016CTP3].[dbo].[SalesPersons]

CollapseAll image

Collapse image Role properties


 Name   Value 
 Name   [SalesPersons] 
 Owner   [dbo] 
 Type   User-defined role 

Collapse image Users and roles with this role


User
david8
garrett1
jae0
jillian0
josé1
linda3
lynn0
michael9
pamela0
rachel0
ranjit0
shu0
tete0
tsvi0

Collapse image Permissions


Object  Alter  Control  Select  Insert  Update  Delete  Execute  DRI  Take
Ownership 
View
Definition 
Send  Receive 
[Sales].[CustomerPII]

Collapse image SQL


CREATE ROLE [SalesPersons] AUTHORIZATION [dbo]
GO

ALTER ROLE [SalesPersons] ADD MEMBER [david8]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [garrett1]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [jae0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [jillian0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [josé1]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [linda3]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [lynn0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [michael9]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [pamela0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [rachel0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [ranjit0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [shu0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [tete0]

GO
ALTER ROLE [SalesPersons] ADD MEMBER [tsvi0]

GO

Collapse image See also


List of roles