--创建表空间

create tablespace TS_ADMIN_DATA ?

? ? ? ? ?logging?

? ? ? ? ?datafile '/mnt/cnbook10/oradata/orcl/TS_ADMIN_DATA .dbf'?

? ? ? ? ?size 1000m

? ? ? ? ?extent MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

?--创建用户

create user ris_u_admin identified by zkt ?

default tablespace TS_ADMIN_DATA ?

--赋权限

grant connect to ris_u_admin;

grant dba to ris_u_admin;

grant resource to ris_u_admin;

-- Grant/Revoke system privileges?

grant create any materialized view to ris_u_admin;

grant create any view to ris_u_admin;

grant create materialized view to ris_u_admin;

grant delete any table to ris_u_admin;

grant drop any cluster to ris_u_admin;

grant insert any table to ris_u_admin;

grant select any table to ris_u_admin;

grant unlimited tablespace to ris_u_admin;

grant update any table to ris_u_admin;