Role: [AdventureWorks2016CTP3].[dbo].[SalesManagers]

CollapseAll image

Collapse image Role properties


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

Collapse image Users and roles with this role


User
amy0
brian3
stephen0
syed0

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 [SalesManagers] AUTHORIZATION [dbo]
GO

ALTER ROLE [SalesManagers] ADD MEMBER [amy0]

GO
ALTER ROLE [SalesManagers] ADD MEMBER [brian3]

GO
ALTER ROLE [SalesManagers] ADD MEMBER [stephen0]

GO
ALTER ROLE [SalesManagers] ADD MEMBER [syed0]

GO

Collapse image See also


List of roles