ORA-00988: missing or invalid password(s)

ORA-00988: missing or invalid password(s)创建账号或修改账号密码时有可能会遇到ORA-00988:missingorinvalidpassword(s),那么什么情况下会遇到这种错误呢?一般是因为密码的设置不符合命名规范:1:密码

大家好,又见面了,我是你们的朋友全栈君。

创建账号或修改账号密码时有可能会遇到ORA-00988: missing or invalid password(s),那么什么情况下会遇到这种错误呢? 一般是因为密码的设置不符合命名规范:

1:密码是关键字,但是没有用双引号包裹起来。

2:密码以数字开头,但是没有用双引号包裹起来

3:密码包含特殊字符,并且没有用双引号包裹起来。

 

官方文档关于passwor的介绍如下:

The BY password clause lets you creates a local user and indicates that the user must specify password to log on to the database. Passwords can contain only single-byte characters from your database character set regardless of whether the character set also contains multibyte characters.

Passwords must follow the rules described in the section “Schema Object Naming Rules”, unless you are using the Oracle Database password complexity verification routine. That routine requires a more complex combination of characters than the normal naming rules permit. You implement this routine with the UTLPWDMG.SQL script, which is further described in Oracle Database Security Guide.

 

而Schema Object Naming Rules就包含下面这些规则。

More usernames than passwords were specified in a GRANT statement. A valid password must be specified for each username listed in the GRANT statement. This error indicates that you are violating the object names and qualifiers for Oracle. The following rules apply when naming objects:

1) Names must be from 1 -30 characters long with the exceptions: – Names of database are limited to 8 characters. – Names of database links can be as long as 128 characters.

2) Names cannot contain quotation marks.

3) Names are not case-sensitive. (注意,这条只适用于ORACLE 10g)

4)A name must begin with and contain an alphanumeric character from your database character set unless surrounded by double quotation marks. 5) Oracle strongly discourages using $ and #.

 

下面我们通过几个案例来了解一下上面的内容吧

 

1:密码是关键字,但是没有用双引号。

SQL> create user test identified by table;
create user test identified by table
                               *
ERROR at line 1:
ORA-00988: missing or invalid password(s)
 
 
SQL> create user test identified by 'table';
create user test identified by 'table'
                               *
ERROR at line 1:
ORA-00988: missing or invalid password(s)
 
 
SQL> create user test identified by "table";
 
User created.

clip_image001

 

2:密码以数字开头,但是没有使用双引号

SQL> create user test identified by 123456;
create user test identified by 123456
                               *
ERROR at line 1:
ORA-00988: missing or invalid password(s)
 
 
SQL> create user test identified by '123456';
create user test identified by '123456'
                               *
ERROR at line 1:
ORA-00988: missing or invalid password(s)
 
 
SQL> create user test identified by "123456";
 
User created.

clip_image002

 

3:密码包含特殊字符,并且没有用双引号。

SQL> drop user test;
 
User dropped.
 
SQL> create user test identified by k*123$6;
create user test identified by k*123$6
                                *
ERROR at line 1:
ORA-00922: missing or invalid option
 
 
SQL> create user test identified by 'k*123$6';
create user test identified by 'k*123$6'
                               *
ERROR at line 1:
ORA-00988: missing or invalid password(s)
 
 
SQL> create user test identified by "k*123$6";
 
User created.

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。

发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/154566.html原文链接:https://javaforall.cn

【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛

【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...

(0)
blank

相关推荐

  • zookeeper实现分布式锁的两种方式

    zookeeper实现分布式锁的两种方式

  • amos路径分析结果怎么看_路径分析图怎么解读

    amos路径分析结果怎么看_路径分析图怎么解读基础准备草堂君在前面几篇文章中,介绍了AMOS软件的操作、分析原理、结构方程模型和各种拟合指标含义等内容,大家可以点击下面的文章链接回顾,也可以从公众号导航栏获取AMOS分析技术(导航页)回顾:AMOS分析技术:软件安装及菜单功能介绍;这次是视频教程AMOS分析技术:结构方程模型的拟合度评价指标AMOS分析技术:模型整体拟合度指标AMOS分析

  • java输入语句怎么写_java输入语句应该怎样写?示例演示

    java输入语句怎么写_java输入语句应该怎样写?示例演示作为初步进入java开发学习的小白来说,就像是小时候刚刚学说话一样,这种经历既是必然的也是有趣的,学习java语言一开始的时候也是得一步步的学习,比如说,java输入语句应该这么去实现呢?一起跟小编来看看吧。第一步:导包。先将java.io.*;以及java.util.*;导入Java代码中。charc=(char)System.in.read();是输入单个字符;inta=cin.nextI…

  • 使用C#创建WebService实例

    使用C#创建WebService实例新增WebService专案更改服务程式名称重命名程式名称Service1.asmx修改为TestService.asmx此时下面的cs代表文件也会跟着修改,但可发现,代码中的类名并没有跟着变动修改类名称手动将类名称由Service1修改为TestService如果此时执行发布会发现还是会vb.net教程有问题,报错無法建立型別‘.Service1’修改服务绑定代码在TestService.asmx上右键选择打开方式,选择“Web服务编辑器”打开此时会看到服务所有设定,

  • Nginx出现403 forbidden

    Nginx出现403 forbiddennginx访问时报403,于是查看nginx日志,路径为/var/log/nginx/error.log。打开日志发现报错Permissiondenied,详细报错如下:1.open()"/data/www/1.txt"failed(13:Permissiondenied),client:192.168.1.194,server:www.web1.com,re…

  • Idea激活码永久有效Idea2018.2.7激活码教程-持续更新,一步到位「建议收藏」

    Idea激活码永久有效Idea2018.2.7激活码教程-持续更新,一步到位「建议收藏」Idea激活码永久有效2018.2.7激活码教程-Windows版永久激活-持续更新,Idea激活码2018.2.7成功激活

发表回复

您的电子邮箱地址不会被公开。

关注全栈程序员社区公众号