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