安装服务器之后,在继续之前必须先考虑某些配置选项。
注: 对于 IBM® i,使用不区分大小写的选项将允许用户标识采用小写字母,而不只是采用大写字母。GRANT DBA TO <data warehouse user>
如果需要考虑此类型的许可权,那么在创建数据仓库之后,您可以使用“报告管理”Web UI 来更改连接规范中的用户。您需要在
JTS、CCM 和 QM 应用程序中更改此值。要创建具有较少许可权的新用户来运行数据收集 (ETL) 作业,请打开 SQL *Plus 窗口并运行下列命令:
CREATE USER <etl db user> PROFILE DEFAULT
IDENTIFIED BY <password> DEFAULT TABLESPACE USERS
ACCOUNT UNLOCK;
ALTER USER <etl db user> TEMPORARY TABLESPACE RIS_TEMP;
ALTER USER <etl db user> QUOTA UNLIMITED ON VNF_32K;
ALTER USER <etl db user> QUOTA UNLIMITED ON VNF_IDX;
ALTER USER <etl db user> QUOTA UNLIMITED ON USERS;
ALTER USER <etl db user> QUOTA UNLIMITED ON VSTR_32K;
ALTER USER <etl db user> QUOTA UNLIMITED ON VSTR_IDX;
GRANT CREATE SESSION TO <etl db user>;
GRANT CONNECT TO <etl db user>;
GRANT DROP ANY TABLE TO <etl db user>;
GRANT EXECUTE ANY PROCEDURE TO <etl db user>;
GRANT ANALYZE ANY TO <etl db user>;
BEGIN
FOR TABNAME IN (SELECT OWNER,TABLE_NAME FROM ALL_TABLES WHERE OWNER IN ('RIODS','RIDW','CONFIG','RIASSET','RISCHK','RICALM'))
LOOP
EXECUTE IMMEDIATE 'GRANT SELECT,UPDATE,DELETE,INSERT ON ' || TABNAME.OWNER || '."' || TABNAME.TABLE_NAME || '" TO <etl db user>';
END LOOP;
END;
/
BEGIN
FOR VNAME IN (SELECT OWNER,VIEW_NAME FROM ALL_VIEWS WHERE OWNER IN ('RIDW','RICALM'))
LOOP
EXECUTE IMMEDIATE 'GRANT SELECT ON ' || VNAME.OWNER || '."' || VNAME.VIEW_NAME || '" TO <etl db user>';
END LOOP;
END;
/
有关 Oracle 数据仓库设置的更多信息,请参阅此 wiki。