SQL Server Administrator - Administrator access permissions for Modeler users
Users with SQL Server Administrator privileges can perform the following tasks:
Information | Allows you to... | But does not allow you to... |
|---|---|---|
SQL Server Administrators can perform tasks similar to Modeler System Administrators on SQL Instances, but cannot access Modeler databases | Through Model Explorer • Create and restore databases • Create, alter and delete logins • Synchronize all groups • Perform database migration | SQL Server Administrators cannot perform any other tasks other than the ones listed in this topic. |