Error Changing User Password

[rickab7]

Guys! Alright?

I would like to know why when I change the password of the user who starts with numbers, Oracle points to me error? Below is an example:

Select all

ALTER USER SHBATISTA IDENTIFIED BY 123;

I know if I use:

Select all

ALTER USER SHBATISTA IDENTIFIED BY VALUES '123'

]] Oracle does not accuse any errors, but if I try to access this user through some application me the failure error login and password.

could anyone give me a help in this sense?

Stay with God

[Trevisolli]

Good afternoon,

Take a look at this reference below:

Schema Object Names and Qualifiers

Same Schema Objects Are Made Up Of Parts That You Can Or Must Name, Such The Columns In A Table Or View, Index and Table Partitions, Integrity Conferints On Table, and Objects That Are Stored Within A package, including procedures and stored functions. • Rules for Naming Schema Objects and Schema Objects
• Guidelines for Naming Schema Objects and Qualifiers

Schema Object Naming Rules

Every Database Object has the name. In A SQL Statement, you represent The Name of An Object with Quote Nonquoted Identifier.
• The Quoted Identifier Begins and Ends With Double Quotation Marks ("). If you name the Schema Object Using the Quoted Identifier, Then You Must Use The Double Quotation Marks Whenever You REFT TO THAT Object.
• Nonquoted Identifier is Not Surrounded by Any Puncture.
That You Not Use Quotation Marks to Make Usernames and Passwords Case Sensitive. Please refer to Additional Rules for Naming Users and Passwords.
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 EXCECTIONS:
• NAMES OF DATABASES ARE LIMITED TO 8 bytes.
• NAMES OF DATABASE LINKS CAN Be the long at 128 bytes.
2. Nonquoted Identifiers Cannot Be Oracle Databa If you reserved Words. Quoted Identifiers Can Be Reserved Words, Although This is not recommended.
Depending on the Oracle Product You Play to Use to Access to Database Object, Names Might Be Further Restricted by Other Product-Specic Reserved Words.

Note:
The reserved Word Rowid is an Exception to this Rule. You cannot use the uppercase Word Rowid A Name, Even in Double Quotation Marks. However, You Can Use The Word With One or More Lower Case Letters (For example, "Rowid" or "Rowid").

Source: http://www.softics.ru/docs/oracle10r2/s ... htm#i27570
Any questions, send us.

[rickab7]

Dude, sorry.

I did not understand anything, can you explain me better?

Hugs

[Trevisolli]

Brother,

tries to create with double quotation marks:

Select all

 
CREATE USER TREVIS IDENTIFIED BY "123455"; 

later, give the Grants of Create Session, in short, and tries to log in:

Select all

 
Connect trevis/123455; 

Whatever, send us to us.

[fneto]

The password 123 is invalid, because it does not follow the minimum requirements, must have at least one letter, for example:

Select all

 ALTER USER SHBATISTA IDENTIFIED BY m123; 

using SQL * plus for example You will see that an error will occur when you try to change the password for 123, but placing a letter will work.

a hug

Fernando Neto


FernandoinTernet@hotmail.com

[fbifabio]

The "Oracle Database 10g: Administration Workshop I" training says a user account must have a unique name of up to 30 characters, excluding special characters, and must start with a letter. Passwords should also start with a letter.

[] s
Fábio Prado www.fabioprado.net