oracle创建用户

sqlplus sys/dwh as sysdba;
prompt 创建采集系统用户
create user xxl_job identified by xxl_job default tablespace TBS_ZDK;
grant connect, resource, select_catalog_role to zdk;
grant imp_full_database, exp_full_database to xxl_job;
grant create any sequence, create any table, select any table, scheduler_admin to xxl_job;
revoke unlimited tablespace from xxl_job;

alter user xxl_job quota unlimited on TBS_ZDK;