Mapping security mechanism login names to server names

Some security mechanisms may allow login names that are not valid in Adaptive Server. For example, login names that are longer than 30 characters, or login names containing special characters such as !, %, *, and & are invalid names in Adaptive Server. All login names in Adaptive Server must be valid identifiers. For information about what identifiers are valid, see Chapter 3, “Expressions, Identifiers, and Wildcard Characters,” in the Reference Manual.

Table 14-5 shows how Adaptive Server converts invalid characters in login names:

Table 14-5: Conversion of invalid characters in login names

Invalid characters

Converts to

  • Ampersand &

  • Apostrophe ’

  • Backslash \

  • Colon :

  • Comma ,

  • Equals sign =

  • Left quote ‘

  • Percent %

  • Right angle bracket >

  • Right quote ’

  • Tilde ~

Underscore _

  • Caret ^

  • Curly braces { }

  • Exclamation point !

  • Left angle bracket <

  • Parenthesis ( )

  • Period .

  • Question mark ?

Dollar sign $

  • Asterisk *

  • Minus sign -

  • Pipe |

  • Plus sign +

  • Quotation marks "

  • Semicolon ;

  • Slash /

  • Square brackets [ ]

Pound sign #