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;