CREATE USER "CRM" IDENTIFIED BY "CRM" --建个用户crm 密码crm
DEFAULT TABLESPACE USERS --用户的默认空间USERS
QUOTA UNLIMITED ON USERS; --不限制
GRANT "AQ_ADMINISTRATOR_ROLE" TO "CRM" WITH ADMIN OPTION; --授予角色,他可以授权
GRANT "DBA" TO "CRM" WITH ADMIN OPTION; --授予用户DBA权限,
GRANT "SALES_HISTORY_ROLE" TO "CRM" WITH ADMIN OPTION; --授予角色
ALTER USER "CRM" DEFAULT ROLE "AQ_ADMINISTRATOR_ROLE", --默认
"DBA",
"SALES_HISTORY_ROLE";
DEFAULT TABLESPACE USERS --用户的默认空间USERS
QUOTA UNLIMITED ON USERS; --不限制
GRANT "AQ_ADMINISTRATOR_ROLE" TO "CRM" WITH ADMIN OPTION; --授予角色,他可以授权
GRANT "DBA" TO "CRM" WITH ADMIN OPTION; --授予用户DBA权限,
GRANT "SALES_HISTORY_ROLE" TO "CRM" WITH ADMIN OPTION; --授予角色
ALTER USER "CRM" DEFAULT ROLE "AQ_ADMINISTRATOR_ROLE", --默认
"DBA",
"SALES_HISTORY_ROLE";
SQL> @ F:\code\sql\ch02\createCrm.sql
CREATE USER "CRM" IDENTIFIED BY "CRM"
*
ERROR at line 1:
ORA-01920: user name 'CRM' conflicts with another user or roleGrant succeeded.
Grant succeeded.GRANT "SALES_HISTORY_ROLE" TO "CRM" WITH ADMIN OPTION
*
ERROR at line 1:
ORA-01919: role 'SALES_HISTORY_ROLE' does not exist
"SALES_HISTORY_ROLE"
*
ERROR at line 3:
ORA-01919: role 'SALES_HISTORY_ROLE' does not exist怎么解决呢?