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: Piotr Cieslewicz <cieslewi_at_do.poznan.tpsa.pl>
Date: Mon, 10 Aug 1998 09:45:28 +0200
Message-ID: <35CEA518.8E790CC0@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 - 02:45:28 CDT

Original text of this message

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