Administration > Database Management > Access permissions > Access permissions required for performing tasks > SQL Server Instance - Administrator access permissions for Modeler users
SQL Server Instance - Administrator access permissions for Modeler users
Assign this Instance administrator access permission to Modeler users that are responsible for setting up databases through one of the following tools:
Model Explorer
ScfUtils command-line
Model Manager
SQL Server Management Studio
Users with this role have administrator access permissions to all Databases, Models and Packages on the SQL Server instance.
Information
Allows you to...
But does not allow you to...
Instance administrators have the following access permissions to all Databases, Models and Packages:
Database - Administrator
Database - Owner
Database - Write
Model - Owner
Model - Write
Model - Read
Package - Owner
Package - Write
Through Model Explorer:
Create or delete a database.
Backup or restore a database.
Add, remove, and manage server logins.
Add, remove, and manage database principals.
Clear locks on a database.
Optimize a database.
Synchronize cached SQL Server user and group access permissions with Active Directory changes.
Set database access permissions.
Set Model access permissions.
Create a Model.
Rename a Model.
Open a Model.
Delete a Model.
Import a Model (new).
Import a Model (updating).
Export a Model.
Clone a Model.
Version a Model.
Protect a Model.
Create a branch.
Reconcile a branch.
Through Modeler:
Set Model access permissions.
Set Package access permissions.
Set Package protection.
Change items scoped by the Model.
Change items scoped by Packages.
Rename and Delete Packages.
Publish Tag Definitions (linked to Stereotypes with model item types defined).
Add profile Packages (containing published Tag Definitions) to a Model.
Create or delete a Change Note.
CM tool integration:
Create a replica of CM tool Model.
Check in, get and check out the Model.
Check in, get and check out Packages.