Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle dbs maximum logon length Question

Re: Oracle dbs maximum logon length Question

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 17 Dec 2003 11:48:11 +1100
Message-ID: <3fdfa7cb$0$18390$afc38c87@news.optusnet.com.au>


Of course I meant dba_users, so my apologies, and thanks for the correction.

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------

"Gerry Sinkiewicz" <sinkiege_at_snet.net> wrote in message
news:DoMDb.41307$__2.22755_at_newssvr31.news.prodigy.com...

> describe DBA_USERS; both password and username varchar2(30)?
>
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
> news:3fdd0f4f$0$18693$afc38c87_at_news.optusnet.com.au...
> >
> > "A. Fuentes" <alvarof2_at_hotmail.com> wrote in message
> > news:oX7Db.125543$Ek.12089_at_twister.austin.rr.com...
> > >
> > > Fellow Oracle Netters:
> > >
> > > Any idea of what is the maximum logon length in number of characters
> > > that the Oracle Database 9i Server supports?
> > >
> > > Is this length the same as a varchar2 type?
> > >
> > > Thanks in advance,
> > >
> > > A. Fuentes
> >
> >
> > You mean the maximum length of a user's name?
> >
> > Try doing a desc dba_tables, and you'll find that it's thirty characters
> > long.
> >
> > Not just a 9i thing, either. It's been like that for ages.
> >
> > Regards
> > HJR
> > --
> > ------------------------------------
> > Oracle insights at www.dizwell.com
> > ------------------------------------
> >
> >
> >
>
>
Received on Tue Dec 16 2003 - 18:48:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US