你的位置:首页 > 数据库

[数据库]Oracle创建用户、表空间并设置权限


代码:

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;