Deleting principals from a database (Model Explorer)
Deleting Principals from a database
 |
Consider the following points before deleting principals from a database:
1. Modeler System Administrators, Database Administrators, and Database owners (dbo users) can delete the roles of principals for a database.
2. Users cannot delete themselves from a database.
3. Modeler System Administrators cannot delete other Modeler System Administrators.
4. Modeler Database Administrators cannot delete other Modeler Database Administrators.
|
To delete 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 delete a principal from.
4. Right-click on the database and select > . The Delete Principal From Database dialog box appears.
5. Select the principal from the Select Principal: list and click OK.
6. A confirmation dialog box is displayed indicating that the selected principal is deleted.