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;
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
- oracle创建用户并赋予sys角色权限
- 创建oracle用户并赋予dba角色的权限
- oracle创建用户并赋予权限
- oracle创建用户并赋予权限
- Oracle 创建表空间,用户,并赋予DBA权限
- mysql创建用户,并赋予权限
- MySql创建hive用户,并赋予权限
- Mysql创建用户并赋予权限
- MySql中创建用户并赋予权限
- mysql创建用户并赋予数据库权限
- mysql创建用户并赋予权限
- MySql_创建用户并赋予权限
- mysql创建用户并赋予权限
- 登录Oracle 并建立用户,赋予权限
- Oracle创建用户、赋予权限的过程
- oracle 创建用户,赋予dba的权限
- oracle 创建用户和赋予权限
- Oracle 创建普通用户,并赋予权限
- Red Hat Enterprise Linux 5中开启Telnet服务
- 怎么给文章增加附加价值
- Unity3D研究院之两种方式播放游戏视频
- Hadoop Permission
- 开博啦!!!
- oracle创建用户并赋予sys角色权限
- VIM 配置
- 蓝桥杯2014年以前JAVA历年真题及答案整理——十六进制转八进制
- 蓝桥杯2014年以前JAVA历年真题及答案整理——十六进制转十进制
- 网站文章如何快速收录
- finalRender R3.5 SE 授权服务 IP-clamp 1.2 安装方法(转)
- 【转】ural 1476
- python nltk 统计语料的词性标注分布
- 蓝桥杯2014年以前JAVA历年真题及答案整理——十进制转十六进制