创建用户脚本
来源:互联网 发布:阿里云2016年宕机 编辑:程序博客网 时间:2024/05/16 23:22
create user a6 identified by "oracle"
default tablespace czck
temporary tablespace temp;
--赋权限:
grant aq_administrator_role to a6;
grant connect to a6;
grant dba to a6;
grant resource to a6;
-- Grant/Revoke system privileges
grant alter any materialized view to a6;
grant create any materialized view to a6;
grant create any table to a6;
grant create any view to a6;
grant create operator to a6;
grant create procedure to a6;
grant create profile to a6;
grant create view to a6;
grant delete any table to a6;
grant drop any materialized view to a6;
grant drop any table to a6;
grant drop any view to a6;
grant execute any operator to a6;
grant execute any procedure to a6;
grant global query rewrite to a6;
grant insert any table to a6;
grant manage tablespace to a6;
grant on commit refresh to a6;
grant query rewrite to a6;
grant select any dictionary to a6;
grant select any sequence to a6;
grant select any table to a6;
grant under any table to a6;
grant under any view to a6;
grant unlimited tablespace to a6;
grant update any table to a6;
default tablespace czck
temporary tablespace temp;
--赋权限:
grant aq_administrator_role to a6;
grant connect to a6;
grant dba to a6;
grant resource to a6;
-- Grant/Revoke system privileges
grant alter any materialized view to a6;
grant create any materialized view to a6;
grant create any table to a6;
grant create any view to a6;
grant create operator to a6;
grant create procedure to a6;
grant create profile to a6;
grant create view to a6;
grant delete any table to a6;
grant drop any materialized view to a6;
grant drop any table to a6;
grant drop any view to a6;
grant execute any operator to a6;
grant execute any procedure to a6;
grant global query rewrite to a6;
grant insert any table to a6;
grant manage tablespace to a6;
grant on commit refresh to a6;
grant query rewrite to a6;
grant select any dictionary to a6;
grant select any sequence to a6;
grant select any table to a6;
grant under any table to a6;
grant under any view to a6;
grant unlimited tablespace to a6;
grant update any table to a6;
0 0
- oracle创建用户脚本
- 创建本地用户脚本
- 创建用户脚本
- 创建用户的脚本
- 用户自动创建脚本
- 用户创建脚本
- shell oracle 创建用户脚本
- 创建linux 用户登录脚本
- linux自动创建用户脚本
- shell脚本自动创建用户
- shell脚本 - 自动创建用户
- 用脚本批量创建用户
- 创建oracle用户脚本及创建同义词
- shell脚本创建用户及批量创建用户
- Oracel 10g 创建用户脚本
- oracle 创建当前database的用户脚本
- oracle创建表空间和用户脚本
- oracle_脚本获取创建用户语句
- 02-线性结构1 一元多项式的乘法与加法运算 -数据结构
- 使用OutputDebugString帮助调试
- 一致性HASH算法的JAVA实现
- [~ Tue, 26 July 2016] Deep Learning in arxiv
- 常用Redis操作命令日记
- 创建用户脚本
- Oracle 中字段属性
- 微信js-sdk 分享 的误解
- 使用JAVA操作netty框架
- linux利用shell实现守护进程的脚本
- Android 下拉刷新控件
- C++ string使用for改变为何必须使用引用
- 心性的刚强,男人
- Laravel 学习笔记——路由(路由与控制器)