Re: Max Password length

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Mon, 9 Mar 2009 11:02:03 -0500
Message-ID: <7b8774110903090902n5555a2bawb1f676ca2df5c45a_at_mail.gmail.com>

Well, blow me down, it *is* 30 bytes (as opposed to characters). =)

BANUPGRD_SQL > select dump('abcdefghijklmnopqrstuvwxyzabcd') from dual;

DUMP('ABCDEFGHIJKLMNOPQRSTUVWXYZABCD')

---

Typ=96 Len=30:
97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,97,98,99,100

BANUPGRD_SQL > drop user test;
drop user test

          *
ERROR at line 1:
ORA-01918: user 'TEST' does not exist

BANUPGRD_SQL > create user test identified by abcdefghijklmnopqrstuvwxyzabcß;
create user test identified by abcdefghijklmnopqrstuvwxyzabcß

                               *

ERROR at line 1:
ORA-00972: identifier is too long

BANUPGRD_SQL > select dump('abcdefghijklmnopqrstuvwxyzabcß') from dual;

DUMP('ABCDEFGHIJKLMNOPQRSTUVWXYZABCß')

---

Typ=96 Len=31:
97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,97,98,99,195,159

On Mon, Mar 9, 2009 at 10:54 AM, Rich Jesse <rjoralist_at_society.servebeer.com
> wrote:

> Hi Ruben,
>
> > What is the maximum password length in oracle 10g
>
> The 10gR1 docs for the CREATE USER statement say:
>
> Passwords must follow the rules described in the section "Schema Object
> Naming Rules ", unless you are using the Oracle Database password
> complexity
> verification routine.
>
> And the Schema Object Naming Rules say:
>
> Names must be from 1 to 30 bytes long
>
> As always, it's best to verify this information in your databases by
> testing.
>
> HTH! GL!
>
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Charles Schultz
Sent from: Champaign Illinois United States.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 09 2009 - 11:02:03 CDT