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. |