Role:
[AdventureWorks2016CTP3].[dbo].[SalesPersons]
Name | Value |
Name | [SalesPersons] |
Owner | [dbo] |
Type | User-defined role |
User |
david8 |
garrett1 |
jae0 |
jillian0 |
josé1 |
linda3 |
lynn0 |
michael9 |
pamela0 |
rachel0 |
ranjit0 |
shu0 |
tete0 |
tsvi0 |
Object | Alter | Control | Select | Insert | Update | Delete | Execute | DRI | Take Ownership |
View Definition |
Send | Receive |
[Sales].[CustomerPII] | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
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 |