CA ERwin Data Modeler Workgroup Edition › Security › Override a User's Inherited Security Permissions

Override a User's Inherited Security Permissions

You can override the security permissions automatically inherited by all permission object classes lower in the class hierarchy.

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 override a user’s inherited security permissions

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 object class or individual object for which you want to override the user’s inherited security permissions in the Object list, select or clear the permissions, and click OK.

   The dialog closes and the inherited security permissions are overwritten.

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.