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 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 |