oracle --- 用户篇

--创建用户
create user gabriel identified by gabriel;
--授权表空间
alter user gabriel default tablespace oa quota unlimited on oa;
alter user gabriel temporary tablespace temp;
grant create trigger to gabriel;
grant create session to gabriel;
grant create sequence to gabriel;
grant create synonym to gabriel;
grant create table to gabriel;
grant create view to gabriel;
grant create procedure to gabriel;
grant alter session to gabriel;
grant execute on ctxsys.ctx_ddl to gabriel;
grant dba to gabriel;
commit;

--查看表空间名字 
select distinct TABLESPACE_NAME from tabs
--查看表空间数量
select count(distinct TABLESPACE_NAME) from tabs

创建maximo空间
CREATE SMALLFILE TABLESPACE"MAXIMO" DATAFILE 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\maximo' 
SIZE 2GAUTOEXTEND ON NEXT 500MMAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
 
注：红色字体部分需要改为实际路径，请查找你oracle安装的路径。
 
22、创建maxdata空间
CREATE SMALLFILE TABLESPACE"MAXDATA" DATAFILE 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA10G\maxdata' 
SIZE 2GAUTOEXTEND ON NEXT 500MMAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
 
注：红色字体部分需要改为实际路径，请查找你oracle安装的路径。
 
 
23、创建用户
create user maximo identified by maximo;
alter user maximo default tablespace maximoquota unlimited on maximo;
alter user maximo temporary tablespacetemp;
grant create trigger to maximo;
grant create session to maximo;
grant create sequence to maximo;
grant create synonym to maximo;
grant create table to maximo;
grant create view to maximo;
grant create procedure to maximo;
grant alter session to maximo;
grant execute on ctxsys.ctx_ddl to maximo;
grant create job to maximo;
grant dba to maximo;
commit;