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 on SQL Instances, but cannot access Modeler databases and also cannot add or remove database level access permissions. | Through Model Explorer • Create and restore databases • Create, alter and delete logins • Synchronize all groups • Perform database migration • Can add and remove only Modeler System Administrators | SQL Server Administrators cannot perform any other tasks other than the ones listed in this topic. |