CA ERwin Data Modeler Workgroup Edition › 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. However, you do not need to assign all users to a security profile immediately after mart creation.

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 assign a user to a security profile

1. Click Mart, Security Manager on the File 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 becomes colored 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.