Role:
[AdventureWorks2016CTP3].[dbo].[SalesManagers]
Role properties
| Name | Value |
| Name | [SalesManagers] |
| Owner | [dbo] |
| Type | User-defined role |
Users and roles with this role
Permissions
| Object | Alter | Control | Select | Insert | Update | Delete | Execute | DRI | Take Ownership |
View Definition |
Send | Receive |
| [Sales].[CustomerPII] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
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 |
See also