oracle 由于权限不足,无法创建角色

pvcm50d1  于 2023-03-29  发布在  Oracle
关注(0)|答案(1)|浏览(175)

我是一名大学生,我正在努力完成我的项目,但我有问题,我不能创建角色。Click this image to see it

CREATE ROLE pharmacist;
CREATE ROLE administrator;

GRANT SELECT, UPDATE ON Patient TO pharmacist;
GRANT SELECT, UPDATE ON Prescription TO pharmacist;

GRANT SELECT, INSERT, UPDATE, DELETE ON Medication TO administrator;
GRANT SELECT, INSERT, UPDATE, DELETE ON pharmacy TO administrator;
GRANT UPDATE ON doctor TO administrator;

GRANT pharmacist TO administrator WITH ADMIN OPTION;

CREATE USER pharmacist_user IDENTIFIED BY pharmacist_password;
GRANT pharmacist TO pharmacist_user;
CREATE USER admin_user IDENTIFIED BY admin_password;
GRANT administrator TO admin_user;

我想知道为什么?我该怎么做?
我试着去创造角色,它应该是工作,但它不是

kcugc4gi

kcugc4gi1#

这失败了:

CREATE ROLE pharmacist;

因为 * 权限不足 *。这意味着不允许您的用户创建角色。
与您的DBA交谈(或者,如果您是DBA,则以特权用户身份连接,例如SYS(如果您没有其他特权用户))以

grant create role to name_of_your_user;

然后创建一个角色。

相关问题