Adding principals to a database (Model Explorer)
To grant users and groups with server login access to a database, you must add them as a database principal.
 |
Modeler System Administrators, Database Administrators and Database owners (dbo user) can add principals to a database. The administrators can also assign database roles to the principals while adding them to the database.
|
To add a principal:
1. Start Model Explorer. For more information, refer to Starting Model Explorer.
2. In the left navigation pane, expand the SQL icon.
3. Expand the server that contains the database you want to add a principal to.
4. Right-click on the database and select > . The Add Principal To Database dialog box appears.
5. From the Select Principal Name dropdown list, select the user that you want to add as a principal.
6. To set the user or group as an administrator, select the Admin check box.
7. Select the access permissions and click OK to add the principal to the database.
If you have added a group, then the database is automatically synchronized with appropriate permissions.