CA ERwin Model Manager › Security › Assign a User to a Security Profile

Assign a User to a Security Profile

You can assign a user to a security profile to control the actions that the user can perform on an 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 assign a user to a security profile

1. Click Security on the Services menu.

   The Security Manager dialog opens. The User list contains all the users that have access to the database. When the user is not assigned to any Security Profile, the name icon appears to be grayed out. This means that the user is not able to log-on to the mart.

2. 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 name displays in the selected security profile. Once the user name is assigned a profile, the icon gets the color to recognize the user name as an active-user.

3. Click OK.

   The dialog closes and the user is assigned to the 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.