Kbase P122206: Can you have a userid in the _User table that is longer than 12 characters?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/03/2008 |
|
Status: Unverified
GOAL:
Can you have a userid in the _User table that is longer than 12 characters?
GOAL:
Is there a maximum length for the _userid field in the _User table?
FIX:
In general, there is no problem in having a userid larger than 12 characters. The Data Dictionary limits it to 12 characters because the default format is X(12). So you should be able to have larger userids but you just won't be able to see the full userid in the 'Edit Security' dialog in the Data Administration tool nor will you be able to enter one through the Data Administration tool). You would need to write a program to add them.