见表空间授权

create tablespace ABSDATA


  logging


  datafile 'D:\oracle\product\10.2.0\oradata\appt\bhabs.dbf'


  size 50m  
 
      autoextend on  
 
      next 50m maxsize 20480m  
 
      extent management local;  


create tablespace ABSINDEX


  logging


  datafile 'D:\oracle\product\10.2.0\oradata\appt\bhabsindex.dbf'


  size 50m  
 
      autoextend on  
 
      next 50m maxsize 20480m  
 

      extent management local; 

    建立用户


rem===================================
create user appt


identified by absserver


default tablespace ABSDATA


temporary tablespace temp


quota unlimited on ABSDATA;


grant connect,resource,dba to appt;

    建立用户


rem===================================
create user abs


identified by abs


default tablespace ABSDATA


temporary tablespace temp


quota unlimited on ABSDATA;


grant connect,resource,dba to abs;

删除用户：

drop user zfmi cascade;