我是一名大学生,我正在努力完成我的项目,但我有问题,我不能创建角色。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;
我想知道为什么?我该怎么做?
我试着去创造角色,它应该是工作,但它不是
1条答案
按热度按时间kcugc4gi1#
这失败了:
因为 * 权限不足 *。这意味着不允许您的用户创建角色。
与您的DBA交谈(或者,如果您是DBA,则以特权用户身份连接,例如SYS(如果您没有其他特权用户))以
然后创建一个角色。