You can change the default database, server role, and user mapping.
|
1 |
Open the SQL Server Security module. |
|
3 |
Select a login, and select Tools | Properties. |
If you are using Microsoft® SQL Server® 2012, 2014, 2016, or 2019, you can manage SRS roles and permissions.
|
1 |
Open the SQL Server Security module. |
|
3 |
Select Server Roles, and select Tools | New. Alternatively, right-click Server Roles, and choose New. |
|
6 |
Click Add to add logins to the selected server role. |
|
7 |
Select the server role, open the Memberships tab, and select the database roles to assign to the server role. |
|
8 |
|
1 |
Open the SQL Server Security module. |
|
3 |
Select a server role, and select Tools | Delete. Alternatively, right-click a server role, and choose Delete. |
|
4 |