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