《biee配置数据库认证方式》由会员分享，可在线阅读，更多相关《biee配置数据库认证方式（4页珍藏版）》请在金锄头文库上搜索。
1、文档供参考，可复制、编制，期待您的好评与关注！ 一、 配置外部表认证方式1. 在数据库中建立用户表和用户组的表2. 建立认证所用的数据源biadmin/*bb-ite-bi-:1521:BIPROD02172.22.5.723. 新建SQL认证，设置认证的数据源、SQL语句及调整认证的顺序i. ReadOnlySqlAuthenticatorii.iii.iv. 配置的SQL语句：SELECT USER_PASSWORD FROM BIADMIN.BIEE_EXTERNAL_USER WHERE USER_NAME = ?SELECT USER_NAME FROM BIADMIN.BIEE_E
2、XTERNAL_USER WHERE USER_NAME = ?SELECT USER_NAME FROM BIADMIN.BIEE_EXTERNAL_USER WHERE USER_NAME LIKE ?SELECT GROUP_NAME FROM BIADMIN.BP_GROUP WHERE GROUP_NAME LIKE ?SELECT GROUP_NAME FROM BIADMIN.BP_GROUP WHERE GROUP_NAME = ?SELECT GROUP_NAME FROM BIADMIN.BP_USER_GROUP A, BIADMIN.BP_GROUP B, BIADMI
3、N.BIEE_EXTERNAL_USER C WHERE A.GROUP_ID = B.GROUP_ID AND A.USER_ID = A.USER_ID AND B.GROUP_NAME = ? AND C.USER_NAME LIKE ?SELECT GROUP_NAME FROM BIADMIN.BP_USER_GROUP A, BIADMIN.BP_GROUP B, BIADMIN.BIEE_EXTERNAL_USER C WHERE A.GROUP_ID = B.GROUP_ID AND A.USER_ID = A.USER_ID AND C.USER_NAME =?SELECT
4、USER_DISPLAYNAME FROM BIADMIN.BIEE_EXTERNAL_USER WHERE USER_NAME = ? SELECT GROUP_DESCRIPTION FROM BIADMIN.BP_GROUP WHERE GROUP_NAME = ?4. 更改属性设置i. 设置控制标签为sufficient，其DefaultAuthenticator也需要设置为sufficient5. You must ensure there is a trusted system user in your database and that you replace the crede
5、ntials in the Credential store to point to this users credentials as described inSection 3.7, Configuring a New Trusted User (BISystemUser).6. 配置虚拟身份存储i. EM中身份存储那个地方新建virtulise,值设置为trueSet the virtualize=true propertyii. 在系统中建立认证的template文件，执行命令进行注册cd /u01/app/biee/product/fmw/oracle_common/modules/
6、oracle.ovd_11.1.1/templates/然后替换adapter_template_usergroup1.xml，adapter_template_usergroup2.xml文件cd /u01/app/biee/product/fmw/oracle_common/binexport ORACLE_HOME=/u01/app/biee/product/fmw/Oracle_BI1export WL_HOME=/u01/app/biee/product/fmw/wlserver_10.3/export JAVA_HOME=/u01/app/biee/product/fmw/Orac
7、le_BI1/jdkcd /u01/app/biee/product/fmw/oracle_common/bin./libovdadapterconfig.sh -adapterName userGroupAdapter1 -adapterTemplate adapter_template_usergroup1.xml -host 172.22.1.249 -port 7001 -userName weblogic -domainPath /u01/app/biee/admin/bifoundation/ -dataStore DB -root cn=users,dc=oracle,dc=co
8、m -contextName default -dataSourceJNDIName DBAuth./libovdadapterconfig.sh -adapterName userGroupAdapter2 -adapterTemplate adapter_template_usergroup2.xml -host 172.22.1.249 -port 7001 -userName weblogic -domainPath /u01/app/biee/admin/bifoundation/ -dataStore DB -root cn=users,dc=oracle,dc=com -contextName default -dataSourceJNDIName DBAuth /
