create tablespace api datafile '/home/software/oracle/api.dbf' size 1500M autoextend on next 5M maxsize 3000M;
# 删除表空间
drop tablespace api including contents and datafiles
# 建用户
create user api_user_rw identified by 123456 default tablespace api;
# 赋权
grant connect,resource to api_user_rw; grant create any sequence to api_user_rw; grant create any table to api_user_rw; grant delete any table to api_user_rw; grant insert any table to api_user_rw; grant select any table to api_user_rw; grant unlimited tablespace to api_user_rw; grant execute any procedure to api_user_rw; grant update any table to api_user_rw; grant create any view to api_user_rw;