huawei--创建用户，角色，授权

create user icd identified by icd default tablespace icd_service temporary tablespace ICD_TEMP
grant dba to icd with admin option
grant execute on sys.dbms_sys_sql to icd with grant option
grant unlimited tablespace to icd
GRANT SELECT ON SYS.DBA_JOBS TO ICD with grant option
/
DROP ROLE ICD_VDNUSER
CREATE ROLE ICD_INTERNAL  
GRANT CREATE SESSION TO ICD_VDNUSER
GRANT DBA TO ICD_INTERNAL
GRANT EXECUTE on sys.dbms_sys_sql to ICD_INTERNAL
GRANT SELECT ON SYS.DBA_JOBS TO ICD_INTERNAL
GRANT CREATE ANY TABLE TO ICD_VDNUSER 
GRANT EXECUTE on spInsertRecordInfoLog TO ICD_VDNUSER
GRANT SELECT ON t_CustLevel to ICD_VDNUSER
/

REVOKE DBA FROM icd1
GRANT RESOURCE ,CONNECT TO icd1
GRANT UNLIMITED TABLESPACE TO icd1
GRANT ALTER SESSION TO icd1
GRANT EXECUTE ANY PROCEDURE TO icd1
GRANT SELECT ANY DICTIONARY TO icd1
GRANT SELECT ANY TABLE TO icd1
GRANT SELECT ANY SEQUENCE TO icd1
GRANT INSERT ANY TABLE TO icd1
GRANT EXP_FULL_DATABASE TO icd1
GRANT IMP_FULL_DATABASE TO icd1
GRANT DELETE ANY TABLE TO icd1
GRANT UPDATE ANY TABLE TO icd1
GRANT DEBUG ANY PROCEDURE TO icd1
GRANT DEBUG CONNECT SESSION TO icd1
/