http://www.mydwbi.com/posts/list/3.page JForum - http://www.jforum.net Database: oracl 11g

我已经建好了一个repository,上次也出这错，但不知道后来怎么就能建了。
现再建一个新的时报错

CREATE VIEW REP_DATABASE_DEFS AS SELECT
DISTINCT
DBDNAM DATABASE_NAME,
SRCNAM DEF_SOURCE,
SUBJ_NAME SUBJECT_AREA,
NULL VERSION_ID,
OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER
FROM OPB_DBD, OPB_SUBJECT, OPB_SRC
WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND
OPB_SRC.DBDID = OPB_DBD.DBDID AND
OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND
OPB_SRC.IS_VISIBLE = 1

ORA-01031: insufficient privileges



已解决
]]> http://www.mydwbi.com/posts/preList/330/1847.page http://www.mydwbi.com/posts/preList/330/1847.page GMT 是不是给用户付的resource角色，resource角色默认没有创建视图权限 ？]]> http://www.mydwbi.com/posts/preList/330/1848.page http://www.mydwbi.com/posts/preList/330/1848.page GMT
我现建了两个repository,那怎么配置informatica Server ?
要用哪个repository,就改informatica Server 的配置么？]]> http://www.mydwbi.com/posts/preList/330/1849.page http://www.mydwbi.com/posts/preList/330/1849.page GMT http://www.mydwbi.com/posts/preList/330/1850.page http://www.mydwbi.com/posts/preList/330/1850.page GMT