话不多说直接上SQL语句。
create user apt
identified by "apt"
default tablespace users
temporary tablespace temp
profile default
account unlock;
grant create procedure to apt;
grant create view to apt;
grant select any table to apt;
grant create table to apt;
grant create session to apt;
grant create sequence to apt;
GRANT "DBA" TO apt;
alter user apt quota unlimited on users;