oracle添加用户及权限

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;