Oracle 用户表空间的创建和授权
--创建表空间
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;
