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: Length of username

Re: Length of username

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: Mon, 10 Aug 1998 07:53:38 -0400
Message-ID: <35CEDF42.8BD4F32F@bms.com>


I stongly agree with this and want to stress the importance of having some standard usernaming convention that everyone follows. Until recently, our company had no such standard, and it makes life unnecessarily complicated. It is also confusing for users to have different usernames on different platforms. We settled on a naming convention that had 8 characters max - this lets us use the same username on a variety of sytems, where 8 character usernames is the lowest common denominator: Oracle, unix, VMS, Novell, etc. If you're the first one in your organization to do this, you may also need to keep a small database to track usernames & who they belong to - with only 8 characters, it's not always obvious.

Joe Kazimierczyk
kazimiej_at_bms.com

Adrian Shepherd wrote:

> Ask your system administrators what policies exist for their servers...Your
> company should have a policy in this regard, if not step in first and set
> the standards.
>
> Piotr Cieslewicz wrote in message <35CEA518.8E790CC0_at_do.poznan.tpsa.pl>...
> >Username is defined as a VARCHAR2(30) data, so it can contains up to 30
> >bytes (it means 30 characters when you're using one byte character set
> >and half of this with two bytes character set). But this is only
> >database limitation not a recomendation.
> >
> >hope this helps
> >
> >Peter
> >
> >Njål A. Ekern wrote:
> >
> >> Can anyone help me out on this?
> >> We are about to make a simple user management-routine in
> >> our application.
> >> When creating users, are there any recommendations regarding
> >> the maximum length of usernames? 8? 13? 16? 30(as in
> >> the dictionary)?...
> >>
> >> We are using v7.3 on HP-Unix.
> >>
> >> TIA,
> >> Njål
> >> --
> >> Njål Arild Ekern, ADB-seksjonen USIT
> >> Postboks 1059 Blindern, 0316 OSLO
> >> Tlf 22852477, fax 22852730
> >
> >
> >
Received on Mon Aug 10 1998 - 06:53:38 CDT

Original text of this message

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