Modeler System Administrator - Administrator access permissions for Modeler users
Users with Modeler System Administrator privileges can perform the following tasks:
Information | Allows you to... | But does not allow you to... |
|---|---|---|
Modeler system administrators can perform a few more tasks than that of SQL Server administrators. Along with creating, restoring and deleting databases, Modeler system administrators can also create principals, change principal roles, and delete principals. Individual database administrator roles of Modeler system administrators cannot be removed. | Through Model Explorer • Create and restore databases • Drop databases • Backup databases • Create, alter and delete logins • Synchronize all groups • View Modeler databases • Set up database administrators • Clear database locks • Start and stop databases • Add, change and delete database principals • Optimize databases • Perform database migration | Modeler system administrators cannot perform any other tasks other than the ones listed in this topic. Modeler system administrators can remove Modeler system administrator roles for other logins only if they have SQL Server Administrator privileges. |