Mapping security mechanism login names to server names

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

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

Table 5-3: 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 #