Error changing password of users

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 05 Jun 2008 2:49 pm

Galera! All right?

I would like to know why when I change the password of the user that start with numbers, Oracle pointed error? Below is an example: ALTER USER IDENTIFIED BY SHBATISTA 123;

I know that if I use: SHBATISTA ALTER USER IDENTIFIED BY VALUES ' 123 ' the Oracle does not accuse any mistakes, however, if I try to access this user through any application of failure error if login and password.

Could someone give me some help in this sense?

Stay with God
rickab7
Location: campo grande

stephany henrique de almeida batista

Poston Thu, 05 Jun 2008 3:08 pm

Good afternoon, take a look at this reference below: Schema Object Names and Qualifiers Add schema objects are made up of parts that you can or must name, such as the columns in the table or view, index and table partitions and subpartitions, integrity constraints on the table, and objects that are stored within the package, including procedures and stored functions. This section provides: • Rules for naming schema objects and schema object location qualifiers • Guidelines for naming schema objects and qualifiers Schema Object Naming Rules Every database object has a name. In the SQL statement, you represent the name of an object with a quoted identifier or a 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 refer to that object.
• The nonquoted identifier is not surrounded by any punctuation.
You can use either quoted or nonquoted identifiers to name any database object, with one exception: database links must be named with nonquoted identifiers. In addition, Oracle strongly recommends that you do not use quotation marks to make usernames and passwords case sensitive. Please refer to CREATE USER for 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 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.
Depending on the Oracle product you plan to use to access the database object, names might be further restricted by other product-specific reserved words.

Note: The reserved word ROWID is an exception to this rule. You cannot use the uppercase word ROWID as 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 it to us.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Thu, 05 Jun 2008 3:39 pm

Man, I'm sorry.

I don't understand anything, can you explain better?

Hugs
rickab7
Location: campo grande

stephany henrique de almeida batista

Poston Thu, 25 Nov 2010 3:56 pm

Brother, attempts to create with double quotes:
Code: Select all
CREATE USER TREVIS IDENTIFIED BY "123455";
then give the grants to create session, anyway, and try to log in:
Code: Select all
Connect trevis/123455;
qualquer thing, send it to us.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Sat, 19 Mar 2011 12:36 am

The password 123 is invalid, do you follow the minimum requirements, must have at least one letter, for example:
Code: Select all
ALTER USER SHBATISTA IDENTIFIED BY m123;
using SQL * PLUS for example you will see that an error occurs when you try to change the password for 123, but putting a letter will work.

A hug Fernando Neto fernandointernet@hotmail.com
fneto
Location: SP

fneto

Poston Thu, 21 Jul 2011 3:28 pm

The training \"Oracle Database 10 g: Administration Workshop I\" says that a user account must have a unique name of up to 30 characters, excluding special characters and must start with a letter. Tbém passwords must start with a letter.

[s] Fabio Prado http://www.fabioprado.net
fbifabio
Location: São Paulo - SP



Return to SQL

Who is online

Users browsing this forum: No registered users and 5 guests