Re: Username and password length !

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 20 Feb 2001 20:13:47 +0100
Message-ID: <t95jgvepvc0uca@beta-news.demon.nl>

SQL> describe dba_users

 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------
-------------
 USERNAME                                              NOT NULL VARCHAR2(30)
 USER_ID                                               NOT NULL NUMBER
 PASSWORD                                                       VARCHAR2(30)
 ACCOUNT_STATUS                                        NOT NULL VARCHAR2(32)
 LOCK_DATE                                                      DATE
 EXPIRY_DATE                                                    DATE
 DEFAULT_TABLESPACE                                    NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE                                  NOT NULL VARCHAR2(30)
 CREATED                                               NOT NULL DATE
 PROFILE                                               NOT NULL VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                                    VARCHAR2(30)

 EXTERNAL_NAME
VARCHAR2(4000) SQL> Hth,

Sybrand Bakker, Oracle DBA

"Radharani Sonnathi" <rsonnathi_at_highground.com> wrote in message news:96u5fl$a1v$1_at_news-in.ConnActivity.com...
> Hi,
>
> Does anybody know the maximum length for username and password for the
> Oraacle ?
> Thanks.
>
> RR
>
>
>
Received on Tue Feb 20 2001 - 13:13:47 CST