Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Length of username
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