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
recently
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 fol
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.
^^^
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 anything
"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 inte
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 l
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.
Thank
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 looke
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 th
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: [EMAIL PROTE
10 matches
Mail list logo