Oracle创建用户、表空间并设置权限
发布时间:2016-04-27 11:00:07
代码:sqlplus /nologconn / as sysdba//创建账号create user techrpt_data identified by techrpt_data ;//创建临时表空间create temporary tablespace TECHRPT_DAT ...
代码:
sqlplus /nologconn / as sysdba//创建账号create user techrpt_data identified by techrpt_data ;//创建临时表空间create temporary tablespace TECHRPT_DATA_TEMPtempfile 'D:\ORACLE\ORADATA\ORCL\TECHRPT_DATA_TEMP.dbf'size 32mautoextend onnext 32m maxsize 2048mextent management local;//将空间分配给用户alter user techrpt_data temporary tablespace TECHRPT_DATA_TEMP;//创建表空间create tablespace TECHRPT_DATA logging datafile 'D:\ORACLE\ORADATA\ORCL\TECHRPT_DATA.ora' size 50m autoextend on next 50m maxsize 2048m extent management local; //将空间分配给用户alter user techrpt_data default tablespace TECHRPT_DATA ;grant sysdba to techrpt_data;grant connect,resource to techrpt_data;grant create session to techrpt_data;grant create any sequence to techrpt_data;grant create any table to techrpt_data;grant delete any table to techrpt_data;grant insert any table to techrpt_data;grant select any table to techrpt_data;grant unlimited tablespace to techrpt_data;grant execute any procedure to techrpt_data;grant update any table to techrpt_data;grant create any view to techrpt_data;commit;quit;//删除用户sqlplussystem/manager@orcl as sysdbadrop user techrpt_data cascade;//用SYS登录,授权给相应的用户,授权SQL如下: (在执行菜单里你可以禁止统计,或在v$session,v$sesstat和v$statname 表里获得选择权限。)grant select on v_$statname to techrpt_data; grant select on v_$sesstat to techrpt_data; grant select on v_$session to techrpt_data; grant select on v_$mystat to techrpt_data; //修改密码SET ORACLE_SID = 你的SID名称sqlplus/nologconnect/as sysdbaalert user sys identified by sysalert user system identified by system//删除表空间drop tablespace techrpt_data including contents and datafiles;
海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com
原标题:Oracle创建用户、表空间并设置权限
关键词:oracle
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。
黑五中小卖家:https://www.goluckyvip.com/tag/7171.html
黑五如何爆单:https://www.goluckyvip.com/tag/7172.html
UPC码获取:https://www.goluckyvip.com/tag/7173.html
高效站内广告:https://www.goluckyvip.com/tag/7174.html
刷脸支付技术:https://www.goluckyvip.com/tag/7175.html
刷手支付技术:https://www.goluckyvip.com/tag/7176.html
深圳到西安自驾路线攻略 深圳到西安自驾最佳路线:https://www.vstour.cn/a/411228.html
松花蛋是哪里的特产松花蛋的产地:https://www.vstour.cn/a/411229.html