Best Practices in Naming Documentum Users and Groups

Constraints:

  1. The maximum allowed length for User and group names is 32 characters.
  2. Do not begin a name with the prefix dm. Documentum reserves this prefix for its own use.
  3. The name must consist of ASCII characters.
  4. User and group names are case sensitive.
  5. It is good practice not to choose names that conflict with DQL reserved words.

Note:

  1. Avoid using SQL and DQL reserved words for names. If a name must match a DQL reserved word, enclose the name in double quotes whenever you use it in a DQL query.
  2. The name must consist of characters compatible with the server os code page of the Content Server
  3. The name of user or group must be unique among the user and group names in the repository. (This means a user cannot have the same name as a group)
  4. It is better to restrict names to letters, digits, underscores. If special characters are used, third-party applications must take special care to escape them while working with Documentum (epecially while using DQL queries)
  5. To escape special characters such as spaces, apostrophes, – enclose the string in Single quotes
  6. To escape DQL reserved keywords, enclose the string in double quotes when referenced
  7. For groups, it was noticed that System changes all characters in the name to lower-case
  8. It was observed in practice that using ‘/’ & ‘\’ in the name causes problems during creation of accounts and user home-cabinets
  9. Other special characters tested were (, ), and the system accepts these names. However, they must be escaped while using DQL queries.

Recommendation:For ensuring that other applications can work with a unified group-set, I recommend that the names should be kept as simple as possible and restricting to letters, digits & underscores. Spaces, apostrophes, brackets, slashes, single-quotes, double-quotes, $, #, @, &, *, etc should be avoided as other applications

Leave a Reply