CREATE USER qdcenter 用户名
IDENTIFIED BY qdcenter 密码
DEFAULT TABLESPACE data1 默认表空间
TEMPORARY TABLESPACE temp1 临时表空间
QUOTA unlimited ON data1
QUOTA unlimited ON temp1
QUOTA unlimited ON idx1
QUOTA unlimited ON rbs1
QUOTA 10M ON system;
GRANT DBA TO qdcenter;DBA权限
grant create table to qdcenter; CReate权限
grant insert any table to qdcenter; insert权限
grant select any table to qdcenter;
grant update any table to qdcenter;
grant delete any table to qdcenter;
grant create any view to qdcenter;
grant drop any view to qdcenter;
grant alter any sequence to qdcenter;
grant create any sequence to qdcenter;
grant select any sequence to qdcenter;
grant drop any sequence to qdcenter;
grant create public synonym to qdcenter;
grant create any synonym to qdcenter;
grant drop public synonym to qdcenter;
grant drop any synonym to qdcenter;