Re: Max Password length

From: Charles Schultz <sacrophyte_at_gmail.com>
Date: Mon, 9 Mar 2009 10:52:21 -0500
Message-ID: <7b8774110903090852v102b1d5fvb2fb316d461f071_at_mail.gmail.com>

They follow the same rules for "normal" database objects; for example, cannot start with a number and limited to 30 characters.

SQL > drop user test;

User dropped.

SQL > create user test identified by abcdefghijklmnopqrstuvwxyzabcd;

User created.

SQL > drop user test;

User dropped.

SQL > create user test identified by abcdefghijklmnopqrstuvwxyzabcde; create user test identified by abcdefghijklmnopqrstuvwxyzabcde

                               *

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

On Mon, Mar 9, 2009 at 10:39 AM, Tieland, RC (Ruben) <r.tieland_at_rocmn.nl>wrote:

> Hi,
>
>
>
> What is the maximum password length in oracle 10g
>
>
>
> thanks and regards,
>
>
>
> Ruben
>
>
>

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

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

Received on Mon Mar 09 2009 - 10:52:21 CDT