PowerDesigner provides default model checks to verify the validity of users, groups, and roles.
Check |
Description and Correction |
---|---|
Name and code uniqueness |
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 |
Code maximum length |
The code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Group categories). andManual correction: Modify the code length to meet this requirement Automatic correction: Truncates the code length to the maximum length specified in the DBMS definition |
Existence of user |
[groups, roles] A group is created to factorize privilege and permission granting to users. A group without user members is useless. Manual correction: Add users to group or delete group Automatic correction: Deletes unassigned group |
Password empty |
[users, groups] Users and groups must have a password to be able to connect to the database. Manual correction: Define a password for the user or group Automatic correction: None |