Database - Owner access permissions for Modeler users
Assign Database Owner access permission to Modeler users that require owner access permissions to all Models and Packages in the database, so that they can perform Model Explorer tasks such as versioning Models.
Information | Allows you to... | But does not allow you to... |
Users with Database Owner access permissions have these access permissions to all database Models and Packages. • Database- Write • Model - Owner • Model - Write • Model - Read • Package - Owner • Package - Write Users with these access permissions also have Database Owner access permissions: • Database - Administrator | Through Model Explorer: • Add, change and delete database principals • Optimize databases • Clear database locks • Backup databases • Start and stop databases • Drop databases • Set model access permissions • Create models • Clone models • Import models (new) • Import models (updating) • Open models • Export models • Rename models • Delete models • Version models • Protect models • Create branches (sandbox) • Reconcile branches (permissions to the tip of the trunk) Through Modeler: • Set Model access permissions • Set Package access permissions • Set Package protection • Change items scoped by a 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 Change Notes | Through Model Explorer: • Create and restore databases • Create, alter, and delete logins • Synchronize all groups • View Modeler databases • Set up database administrators |