Oracle中添加新用户

最新推荐文章于 2024-03-19 10:36:55 发布

BIT工匠

最新推荐文章于 2024-03-19 10:36:55 发布

阅读量881

点赞数

本文链接：https://blog.csdn.net/jollypigclub/article/details/46459791

版权

[oracle@TEST ~]$ sqlplus / as sysdba




--顺序执行以下步骤


--删除用户（可选）
SQL> drop user teacher cascade;






--索引空间： teacher_index
--数据空间: teacher_data


CREATE TABLESPACE teacher_data LOGGING 
     DATAFILE '/u01/app/oracle/oradata/teacher/teacher_data01.dbf' SIZE 10240M REUSE AUTOEXTEND OFF, 
     '/u01/app/oracle/oradata/teacher/teacher_data02.dbf' SIZE 10240M REUSE AUTOEXTEND OFF,
     '/u01/app/oracle/oradata/teacher/teacher_data03.dbf' SIZE 10240M REUSE AUTOEXTEND OFF 
     EXTENT MANAGEMENT LOCAL;


CREATE TABLESPACE teacher_index LOGGING 
     DATAFILE '/u01/app/oracle/oradata/teacher/teacher_index01.dbf' SIZE 10240M REUSE AUTOEXTEND OFF,
     '/u01/app/oracle/oradata/teacher/teacher_index02.dbf' SIZE 10240M REUSE AUTOEXTEND OFF,
     '/u01/app/oracle/oradata/teacher/teacher_index03.dbf' SIZE 10240M REUSE AUTOEXTEND OFF 
     EXTENT MANAGEMENT LOCAL;
     
--临时表空间：
create temporary tablespace teacher_tmp  
tempfile '/u01/app/oracle/oradata/teacher/tmp0001.dbf' size 10000M  
autoextend on  
extent management local; 




--创建用户并指定表空间
create user teacher identified by drawing_teacher
default tablespace teacher_data 
temporary tablespace teacher_tmp 
quota unlimited on teacher_data;


--给用户授予权限
grant connect,resource,dba to teacher;