Reusing Permission Assignments Using Permission Templates

You can create your own Permission Templates to reuse permission assignments for different database objects. This saves you the tedious work of manually granting the same set of permissions to users and groups for multiple database object. Creating your own permission templates also enables you to propagate permission requirement changes to multiple database objects by only updating the permissions in one place — the permission assignments of the permission template itself.


	Updating the permission assignments for a permission template affects not only future applications of the template but also the permissions of database objects to which the template has already been applied.

Predefined Permission Templates

Model Manager comes with three predefined permission templates for each of the database object types — , , and . Dividing the permissions in the Permission Catalog into read permissions and write permissions:

Table 2-10: The permissions granted for the predefined permission templates.
Permission template name	Granted read permissions	Granted write permissions
Public	Everyone	Everyone
Protected	Everyone	Owner
Private	Owner	Owner

Creating your own Permission Templates

You can create new permission templates for models or files in the Model Manager workspace.

Click (

) in the section of the toolbar to open the dialog box. The field shows the label of the database in which the template is added.

Write the name of the permission template in the field.

Select whether to add a or permission template in the field.

You add, edit, and remove granted permissions and their grantees in a table in the same way as when selecting in the field for a database object — see Custom Permissions.

Click to add the new permission template to the database.

The added permission template appears as a new child node to the node under in The Databases Tree.