ORA-28022: cannot grant external roles to global user or role

ORA-28022: cannot grant external roles to global user or role
Cause: A role granted was IDENTIFIED EXTERNALLY. External roles cannot be granted to global users or global roles.
Action: Use ALTER ROLE to change the type of the role being granted (from IDENTIFIED EXTERNALLY to other, such as IDENTIFIED BY password), or use ALTER ROLE or ALTER USER to change the type of the user or role that is the grantee.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:47

ORA-28022：不能将外部角色授予全局用户或角色,
.原因：授予的角色为EXTERNALLY IDENTIFIED。不能将外部角色授予全局用户或全局角色。,
.操作：使用ALTER ROLE更改要授予的角色类型（从IDENTIFIED EXTERNALLY更改为其他，例如IDENTIFIED BY密码），或者使用ALTER ROLE或ALTER USER更改受让人的用户或角色的类型。,
.

aiaiDBA

13718043309

010-86462881

ORA-28022: cannot grant external roles to global user or role

1 个回答

相似问题