CA ERwin Data Modeler Workgroup Edition › Security › Change a Profile's Permissions

Change a Profile's Permissions

You can change the permissions associated with a security profile to restrict access or add access to models.

Note: The owner of the database (dbo) always supersedes any security provided on the mart. If the database owner is assigned the Viewer profile, that user is still able to change security profiles because the database owner is the Mart Administrator by default, regardless of the profile assigned in the Security Manager.

To change the permissions associated with a security profile

1. Click Mart, Security Manager on the File menu.

   The Security Manager dialog opens.

2. Click Profile.

   The Security Profile Manager dialog opens.

3. Select the profile (for example, Architect) and click the appropriate object class (for example, Mart), and select one of the following options:
   • To grant permission to perform an activity, select the permission box.
   • To remove permission to perform an activity, clear the permission box.

   Important! Changing the Guest security profile is not permitted.

4. Click OK.

   The permissions are updated for that security profile.

Note: You must be assigned to the Administrator security profile for the mart to add, update, or delete a security profile. While only an administrator can change permissions associated with a profile, anyone can view the permissions.