biee配置数据库认证方式

《biee配置数据库认证方式》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、一、配置外部表认证方式1.在数据库中建立用户表和用户组的表2.建立认证所用的数据源biadmin/*****bb-ite-bi-racdb02.bb01.baidu.com:1521:BIPROD02172.22.5.723.新建SQL认证，设置认证的数据源、SQL语句及调整认证的顺序i.ReadOnlySqlAuthenticatorii.i.ii.配置的SQL语句：SELECTUSER_PASSWORDFROMBIADMIN.BIEE_EXTERNAL_USERWHEREUSER_NAME=?SELECTUSER_NAMEFROMBIADMIN.B

2、IEE_EXTERNAL_USERWHEREUSER_NAME=?SELECTUSER_NAMEFROMBIADMIN.BIEE_EXTERNAL_USERWHEREUSER_NAMELIKE?SELECTGROUP_NAMEFROMBIADMIN.BP_GROUPWHEREGROUP_NAMELIKE?SELECTGROUP_NAMEFROMBIADMIN.BP_GROUPWHEREGROUP_NAME=?SELECTGROUP_NAMEFROMBIADMIN.BP_USER_GROUPA,BIADMIN.BP_GROUPB,BIADMIN.BIEE

3、_EXTERNAL_USERCWHEREA.GROUP_ID=B.GROUP_IDANDA.USER_ID=A.USER_IDANDB.GROUP_NAME=?ANDC.USER_NAMELIKE?SELECTGROUP_NAMEFROMBIADMIN.BP_USER_GROUPA,BIADMIN.BP_GROUPB,BIADMIN.BIEE_EXTERNAL_USERCWHEREA.GROUP_ID=B.GROUP_IDANDA.USER_ID=A.USER_IDANDC.USER_NAME=?SELECTUSER_DISPLAYNAMEFROMBI

4、ADMIN.BIEE_EXTERNAL_USERWHEREUSER_NAME=?SELECTGROUP_DESCRIPTIONFROMBIADMIN.BP_GROUPWHEREGROUP_NAME=?1.更改属性设置i.设置控制标签为sufficient，其DefaultAuthenticator也需要设置为sufficient2.YoumustensurethereisatrustedsystemuserinyourdatabaseandthatyoureplacethecredentialsintheCredentialstoretopointto

5、thisuser'scredentialsasdescribedin Section3.7,"ConfiguringaNewTrustedUser(BISystemUser)".3.配置虚拟身份存储i.EM中身份存储那个地方新建virtulise,值设置为trueSetthevirtualize=truepropertyi.在系统中建立认证的template文件，执行命令进行注册cd/u01/app/biee/product/fmw/oracle_common/modules/oracle.ovd_11.1.1/templates/然后替换adapte

6、r_template_usergroup1.xml，adapter_template_usergroup2.xml文件cd/u01/app/biee/product/fmw/oracle_common/binexportORACLE_HOME=/u01/app/biee/product/fmw/Oracle_BI1exportWL_HOME=/u01/app/biee/product/fmw/wlserver_10.3/exportJAVA_HOME=/u01/app/biee/product/fmw/Oracle_BI1/jdkcd/u01/app/

7、biee/product/fmw/oracle_common/bin./libovdadapterconfig.sh-adapterNameuserGroupAdapter1-adapterTemplateadapter_template_usergroup1.xml-host172.22.1.249-port7001-userNameweblogic-domainPath/u01/app/biee/admin/bifoundation/-dataStoreDB-rootcn=users,dc=oracle,dc=com-contextNamedefa

8、ult-dataSourceJNDINameDBAuth./libovdadapterconf