Oracle创建用户设置权限

/*第1步：创建临时表空间  */

create temporary tablespace db_temp tempfile 'D:/dboa/oracle/db_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create temporary tablespace htoa_temp tempfile  '/home/oracle/htoa_temp.dbf'  size 50m autoextend on next 50m maxsize 20480m extent management local;

/*第2步：创建数据表空间  */

create tablespace db_data logging datafile ' D:/dboa/oracle/db_data.dbf ' size 50m autoextend on next 50m maxsize 2048m extent management local;  

create tablespace htoa_data logging datafile '/home /oracle/ htoa_data .dbf ' size 50m autoextend on next 50m maxsize 2048m extent management local;  

/*第3步：创建用户并指定表空间  */

create user htoa identified by htoa default tablespace htoa_data temporary tablespace htoa_temp ;

/*第4步：给用户授予权限  */

grant connect,resource,dba to htoa ;

/*删除用户 */

drop user htoatemp cascade