The length of the authorization identifier and the permitted characters depend on the system with which connection is established. Table 27-2 shows the permitted authorization identifier length, and Table 27-3 shows the permitted characters that can be used in an authorization identifier.
Table 27-2 Permitted authorization identifier length
System to be connected | Permitted authorization identifier length |
---|---|
HiRDB | Maximum 8 characters |
ORACLE | Maximum 8 characters* |
XDM/RD | Maximum 7 characters |
RDB1 E2 | Maximum 8 characters |
SQL/K | Maximum 7 characters |
* When Oracle is the distributed client, a maximum of 7 characters is permitted for the authorization identifier used to establish connection with HiRDB.
Table 27-3 Characters permitted in an authorization identifier
System to be connected | Characters permitted in authorization identifier | |||||
---|---|---|---|---|---|---|
A-Z | a-z | 0-9 | # | @, \ | Other | |
HiRDB | Y | Y | Y | Y | Y | N |
ORACLE | Y | Y | Y | Y | N | N |
XDM/RD | Y | N | Y | Y | Y | N |
RDB1 E2 | Y | N | Y | Y | Y | N |
SQL/K | Y | N | Y | Y | Y | N |
Y: Permitted.
N: Not permitted.