oracle创建用户并赋予sys角色权限

来源:互联网 发布:淘宝店新开怎么推广 编辑:程序博客网 时间:2024/06/04 18:53
-- 创建用户
create user WQ
  identified by "123456"
  default tablespace SYSTEM
  temporary tablespace TEMP
  profile DEFAULT;
-- 连接到SYS用户下去授权
grant execute on SYS.DBMS_ALERT to WQ;
grant execute on SYS.DBMS_AQ to WQ with grant option;
grant execute on SYS.DBMS_AQADM to WQ with grant option;
grant execute on SYS.DBMS_AQELM to WQ with grant option;
grant execute on SYS.DBMS_AQ_IMPORT_INTERNAL to WQ with grant option;
grant execute on SYS.DBMS_DEFER_IMPORT_INTERNAL to WQ;
grant execute on SYS.DBMS_REPCAT to WQ;
grant execute on SYS.DBMS_RULE_EXIMP to WQ with grant option;
grant execute on SYS.DBMS_SQL to WQ;
grant execute on SYS.DBMS_SYS_ERROR to WQ;
grant execute on SYS.DBMS_SYS_SQL to WQ;
grant execute on SYS.DBMS_TRANSFORM_EXIMP to WQ with grant option;
grant select, insert, update, delete, references, alter, index on SYS.INCEXP to WQ;
grant select, insert, update, delete, references, alter, index on SYS.INCFIL to WQ;
grant select, insert, update, delete, references, alter, index on SYS.INCVID to WQ;
grant select on WMSYS.WM$UDTRIG_INFO to WQ;
grant aq_administrator_role to WQ with admin option;
grant dba to WQ with admin option;
grant unlimited tablespace to WQ with admin option;
0 0
原创粉丝点击