Role Checks (PDM)

PowerDesigner provides default model checks to verify the validity of roles.

Check	Description and Correction
Role name and code uniqueness	Role names and codes must be unique in the model. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code
Role code maximum length	The role code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > Role category) or in the naming conventions of the model options. Manual correction: Modify the role code length to meet this requirement Automatic correction: Truncates the role code length to the maximum length specified in the DBMS definition
Existence of user	A role is used to create predefined profile that can be assigned to users or roles. A role that is not assigned to any user or role is useless. Manual correction: Assign role to users or delete role Automatic correction: Deletes unassigned role

Check

Description and Correction

Role name and code uniqueness

Role names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Role code maximum length

The role code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > Role category) or in the naming conventions of the model options.

Manual correction: Modify the role code length to meet this requirement

Automatic correction: Truncates the role code length to the maximum length specified in the DBMS definition

Existence of user

A role is used to create predefined profile that can be assigned to users or roles. A role that is not assigned to any user or role is useless.

Manual correction: Assign role to users or delete role

Automatic correction: Deletes unassigned role