Home » RDBMS Server » Security » rule / format for the username and password
rule / format for the username and password [message #116205] Mon, 18 April 2005 10:13 Go to next message
vban2000
Messages: 207
Registered: March 2005
Senior Member
hi, fellow gurus

I am creating a procedure for creating user, and I wanted to know what are the rules or format that one should obey when creating the username and password.

e.g. username cannot start with number? maximum length??

any one have any ideas??

here is the article I found, which outlines some rules / format for the password:

http://asktom.oracle.com/pls/ask/f?p=4950:8:2474774733326624695::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:595223460734

many thx in advance
Andy
Re: rule / format for the username and password [message #116212 is a reply to message #116205] Mon, 18 April 2005 10:30 Go to previous message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
See the SQL Reference Guide - "CREATE USER":

"Specify the name of the user to be created. This name can contain only characters from your database character set and must follow the rules described in the section "Schema Object Naming Rules". Oracle recommends that the user name contain at least one single-byte character regardless of whether the database character set also contains multibyte characters."

"The following list of rules applies to both quoted and nonquoted identifiers unless otherwise indicated:

1. Names must be from 1 to 30 bytes long with these exceptions:

- Names of databases are limited to 8 bytes.

- Names of database links can be as long as 128 bytes.

2. Nonquoted identifiers cannot be Oracle Database reserved words. Quoted identifiers can be reserved words, although this is not recommended."

Also read this article by Jared Still - http://www.orafaq.com/articles/archives/000064.htm

Best regards.

Frank
Previous Topic: Adding a user
Next Topic: Dynamically Populating View Data based on User
Goto Forum:
  


Current Time: Sat Aug 15 10:05:47 CDT 2020