Oracle User Password principle

Today, when you modify a user's password in an Oracle database, you find the following rule

1 passwords are composed only of letters and created successfully

Sql> ALTER user ICS identified by password;

User changed.

2 passwords are only made up of numbers and created successfully

Sql> ALTER user ICS identified by 123456;

User changed.

3 password consists of letter + number, created successfully

Sql> ALTER user ICS identified by password123;

User changed.

4 password consists of number + letters, creation failed

Sql> ALTER user ICS identified by 1q2w3e;

ERROR at line 1:

ora-00922:missing or Invalid option

5 When a password consists of a number + password, double quotes must be added to succeed

Sql> ALTER user ICS identified by "1q2w3e";

User changed.

Sql> Conn ics/1q2w3e

Connected.

When creating users

This article is from the "record a bit of learning life" blog, please make sure to keep this source http://laobaiv1.blog.51cto.com/2893832/1921831

Oracle User Password principle