oracle数据库角色、用户、存储空间…

create tablespace tablespace_name

datafile 'D:\app\GaoFei\oradata\tablespace_name01.dbf'

size 500M autoextend on next 50M maxsize unlimited;

--User create

CREATE USER programer

IDENTIFIED BY programer

DEFAULT TABLESPACE tablespace_name

QUOTA unlimited ON tablespace_name;

--Role create

CREATE ROLE programer_role

NOT IDENTIFIED;

GRANT CREATE SESSION, ALTER SESSION, MANAGE TABLESPACE,

BACKUP ANY TABLE, CREATE USER, ALTER USER, DROP USER,

CREATE ROLE, ALTER ANY ROLE, DROP ANY ROLE, GRANT ANY ROLE,

ALTER DATABASE, CREATE ROLLBACK SEGMENT,

ALTER ROLLBACK SEGMENT, DROP ROLLBACK SEGMENT,

CREATE TABLESPACE, ALTER ANY TABLE, DROP ANY TABLE,

CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX,

CREATE ANY VIEW, DROP ANY VIEW, CREATE ANY CLUSTER,

ALTER ANY CLUSTER, DROP ANY CLUSTER

TO programer_role WITH ADMIN OPTION;

GRANT programer_role TO programer;

GRANT dba TO programer WITH ADMIN OPTION;

ALTER USER programer

DEFAULT ROLE all;