Home » RDBMS Server » Server Administration » Valid password characters
Valid password characters [message #370488] Fri, 03 December 1999 10:33 Go to next message
ambrose
Messages: 2
Registered: December 1999
Junior Member
Is there any formal documentation on which characters
should NOT be used in a password on UNIX v7.3.4 US7ASCII? Seems @ and & cause pain, but I haven't found formal documentation.
Re: Valid password characters [message #370495 is a reply to message #370488] Mon, 06 December 1999 14:37 Go to previous message
hmg
Messages: 40
Registered: March 1999
Member
Look at Oracle SQL reference especially by the "create user" command:

by password:
requires the user to specify this password to log on. Password must follow the rules described in the
section "Schema Object Naming Rules" and can only contain single-byte characters from your database
character set regardless of whether this character set also contains multibyte characters.

==>

Schema Object Naming Rules

The following rules apply when naming schema objects:

1.Names must be from 1 to 30 characters long with these exceptions:
Names of databases are limited to 8 characters.
Names of database links can be as long as 128 characters.
2.Names cannot contain quotation marks.
3.Names are not case sensitive.
4.A name must begin with an alphabetic character from your database character set unless surrounded by double quotation marks.
5.Names can contain only alphanumeric characters from your database character set and the characters _, $, and #. Names of database links can also contain
periods (.) and at signs (@). Oracle strongly discourages you from using $ and #.
.....
.....

I interpret this section that valid characters are in the
set {'a',..,'z','0',..,'9','_','$','#'),
where additional the password must begin with a letter
Previous Topic: need help with dynamic sql.
Next Topic: Re: CLOB to VARCHAR2
Goto Forum:
  


Current Time: Wed Oct 21 11:52:58 CDT 2020