Kbase P67278: How to create a userid in the _user table that is more than twelve characters
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/4/2008 |
|
Status: Verified
GOAL:
How to create a userid in the _user table that is more than twelve characters
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?
GOAL:
How to create a userid in the _user table that is more than 12 characters
FACT(s) (Environment):
All Supported Operating Systems
FIX:
Userid's being added via the Data Administration/Data Dictionary tool cannot be more the 12 characters because the default format is X(12). This does not fully prevent the _user table from having userids with more than twelve characters, 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.
Users can be added via a 4GL program. For example:
CREATE _user.
ASSIGN
_User._UserId = "administrator"
_User._Password = ENCODE("administrator").