But if you don't use double quotes the only symbols I've gotten to work are
#, $ and _
-Original Message-
Sent: Tuesday, November 11, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L
In article [EMAIL PROTECTED], Stephane Faroult
[EMAIL PROTECTED] writes
Ron,
Passwords follow
Hi Jay
Exactly, you can use the same symbols as other database objects but if
you use double quotes any character can be used even control characters.
The point i was making was that even between the double quotes letters
a-z are not case sensitive. I proved this with an example for Jared
In article [EMAIL PROTECTED], Stephane Faroult
[EMAIL PROTECTED] writes
Ron,
Passwords follow the same rules as identifiers, they are internally
managed exactly as identifiers.
Maximum length is 30 and anthing goes between double quotes.
it's in the Schema Naming Rules (I think that's the section) of the SQL
Reference manual.
A little creative thinking got me to create user in the SQL manual
and from there to the hyperlink to the Naming Rules.
On top of that, you can write your own password verification routine
and put it in the
Look in the manual at table naming rules. As I recall Oracle passwords
follow the same general rules as table names.
--Walt Weaver
Bozeman, Montana
On Mon, 2003-11-10 at 12:19, Smith, Ron L. wrote:
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked
Ron,
additional info
Oracle Press Oracle 8i DBA Handbook pg 396 - 402
Ron
[EMAIL PROTECTED] 11/10/2003 2:19:26 PM
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find anything.
Thanks!
Ron
Version 8i.
The Oracle password complexity routine is activated if you run the
rdbms/admin/utlpwdmg.sql
It basicaly checks for passwords from a common name list, checks if the
password contains at least one char, one digit, and one punctuation. It
also checks if the new is different by 3
Smith, Ron L. wrote:
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find anything.
Thanks!
Ron Smith
Ron,
Passwords follow the same rules as identifiers, they are internally
why? Smith
Neo
-Original Message-
Sent: Monday, November 10, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find
