无效的普通用户或角色名称 [英] Invalid common user or role name

问题描述

这为什么显示错误.

SQL> create user nisar identified by kk ;
create user nisar identified by kk
            *

第1行出现错误:

ERROR at line 1:

ORA-65096:无效的普通用户或角色名称

ORA-65096: invalid common user or role name

推荐答案

您正在尝试使用无效名称创建普通用户，而不是容器用户:

You're trying to create a common user, not a container user, with an invalid name:

ORA-65096:无效的普通用户或角色名称
原因:试图创建名称对普通用户或角色无效的普通用户或角色.除了用于用户名和角色名的常规规则之外，常见的用户名和角色名还必须以C ##或c ##开头，并且仅由ASCII字符组成.
行动:指定一个有效的普通用户或角色名称.

ORA-65096: invalid common user or role name
Cause: An attempt was made to create a common user or role with a name that wass not valid for common users or roles. In addition to the usual rules for user and role names, common user and role names must start with C## or c## and consist only of ASCII characters.
Action: Specify a valid common user or role name.

如果要在特定容器中创建用户，则可以先使用alter session set container，因此将create应用于该容器中.如果您确实想要普通用户，请遵循上面的命名规则.

If you want to create a user in a particular container then you can use the alter session set container first, so your create is applied within that container. If you really do want a common user, follow the naming rules above.

阅读文档中的更多内容.

这篇关于无效的普通用户或角色名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！