oracle頂級使用者，建角色

頂級使用者：

使用者名稱：sys

連結為：SYSDBA

建角色：

 /*建立關務V2.0配置庫*/    DROP TABLESPACE CMS_PARA INCLUDING CONTENTS AND DATAFILES;    CREATE TABLESPACE CMS_PARA    LOGGING     DATAFILE     'D:\oracle\oradata\orcl\CMS_PARA.ORA' SIZE 5M --oracle的安裝路徑    REUSE AUTOEXTEND     ON NEXT  1024K MAXSIZE  32767M    EXTENT MANAGEMENT LOCAL     SEGMENT SPACE MANAGEMENT  AUTO;        /*建立關務V2.0配置庫使用者*/    DROP USER CMS_PARA;    CREATE USER CMS_PARA  PROFILE "DEFAULT"     IDENTIFIED BY "dcjet" DEFAULT TABLESPACE "CMS_PARA"     TEMPORARY TABLESPACE "TEMP"     ACCOUNT UNLOCK;        GRANT CONNECT TO CMS_PARA;    GRANT DBA TO CMS_PARA;    ALTER USER "CMS_PARA" DEFAULT ROLE  ALL;        /*建立關務V2.0業務庫*/    DROP TABLESPACE CMS_BUS INCLUDING CONTENTS AND DATAFILES;    CREATE TABLESPACE CMS_BUS    LOGGING     DATAFILE     'D:\oracle\oradata\orcl\CMS_BUS.ORA' SIZE 5M     REUSE AUTOEXTEND     ON NEXT  1024K MAXSIZE  32767M    EXTENT MANAGEMENT LOCAL     SEGMENT SPACE MANAGEMENT  AUTO;            /*建立關務V2.0業務庫使用者*/    DROP USER CMS_BUS;    CREATE USER CMS_BUS  PROFILE "DEFAULT"     IDENTIFIED BY "dcjet" DEFAULT TABLESPACE "CMS_BUS"     TEMPORARY TABLESPACE "TEMP"     ACCOUNT UNLOCK;        GRANT CONNECT TO CMS_BUS;    GRANT DBA TO CMS_BUS;    ALTER USER "CMS_BUS" DEFAULT ROLE  ALL;