PowerDesigner provides default model checks to verify the validity of groups.
Check |
Description and Correction |
---|---|
Group name and code uniqueness |
Group 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 |
Group code maximum length |
The group 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 group code length to meet this requirement Automatic correction: Truncates the group code length to the maximum length specified in the DBMS definition |
Existence of user |
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 |
Group password empty |
Groups must have a password to be able to connect to the database (for those DBMS that support passwords for groups.) Manual correction: Define a password for the group Automatic correction: None |