Skip to content

Commit fc2bb28

Browse files
authored
Merge pull request #18047 from MicrosoftDocs/VanMSFT-patch-1
Update getting-started-with-database-engine-permissions.md
2 parents ceedb8e + da9856a commit fc2bb28

1 file changed

Lines changed: 4 additions & 6 deletions

File tree

docs/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions.md

Lines changed: 4 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -75,15 +75,13 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
7575

7676
#### If the person connecting will be connecting to only one database
7777

78-
1. Create a login for the Windows groups. (If using [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] authentication, skip the Active Directory steps, and create [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] authentication logins here.)
78+
1. In the user database, create a contained database user for the Windows group. (If using [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] authentication, skip the Active Directory steps, and create contained database user [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] authentication here.
7979

80-
2. In the user database, create a contained database user for the Windows group. (If using [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] authentication, skip the Active Directory steps, and create contained database user [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] authentication here.
80+
1. In the user database, create one or more user-defined database roles, each representing a similar function. For example financial analyst, and sales analyst.
8181

82-
3. In the user database, create one or more user-defined database roles, each representing a similar function. For example financial analyst, and sales analyst.
82+
1. Add the database users to one or more user-defined database roles.
8383

84-
4. Add the database users to one or more user-defined database roles.
85-
86-
5. Grant permissions to the user-defined database roles.
84+
1. Grant permissions to the user-defined database roles.
8785

8886
The typical result at this point, is that a Windows user is a member of a Windows group. The Windows group has a login in [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] or [!INCLUDE[ssSDS](../../../includes/sssds-md.md)]. The login is mapped to a user identity in the user-database. The user is a member of a database role. Now you need to add permissions to the role.
8987

0 commit comments

Comments
 (0)