CA ERwin Data Modeler Workgroup Edition › 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 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 modify a user’s security profile

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