CA ERwin Model Manager › Security › Modify a User's Security Profile

Modify a User's Security Profile

You can assign a user to a particular security profile to control the actions that the user can perform on a given type of object. By assigning a user to more than one security profile, you can customize each user’s rights to manipulate objects in the mart. You must assign at least one security profile to each user.

Note: The db_owner of the database always supersedes any security CA ERwin MM provides on the mart. If the db_owner is assigned the Viewer profile, it is still able to change security profiles because the db-owner is the mart administrator by default regardless of the profile assigned in the Security Manager.

To modify a user’s security profile

1. Click Security on the Services menu.

   The Security Manager dialog opens.

2. Expand the list of user names for the appropriate profile in the Security Profile list.

   The user names display in the Security Profile list.

3. Select the user for which you want to modify security permissions and drag the icon for the user from the Security Profile list to the User list.

   The selected user is removed from the Security Profile list.

4. Select the user for which you want to assign security and drag the icon for the user from the User list onto the security profile icon in the Security Profile list.

   The user is assigned the new security profile.

5. Click OK.

   The dialog is closed and the user’s security profile is modified.

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.