biee配置数据库认证方式.docx

一、 配置外部表认证方式1. 在数据库中建立用户表和用户组的表2. 建立认证所用的数据源biadmin/*:1521:BIPROD0223. 新建SQL认证，设置认证的数据源、SQL语句及调整认证的顺序i. ReadOnlySqlAuthenticatorii.iii.iv. 配置的SQL语句：SELECT USER_PASSWORD FROM BIADMIN.BIEE_EXTERNAL_USER WHERE USER_NAME = ?SELECT USER_NAME FROM BIADMIN.BIEE_EXTERNAL_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, BIADMIN.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 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 credentials 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/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/Oracle_BI1/jdkcd /u01/app/biee/product/fmw/oracle_common/bin./libovdadapterconfig.sh -adapterName userGroupAdapter1 -adapterTemplate adapter_template_usergroup1.xml -host 49 -port 7001 -userName weblogic -domainPath /u01/app/biee/admin/bifoundation/ -dataStore DB -root cn=users,dc=oracle,dc=com -contextName default -dataSourceJNDIName DBAuth./libovdadapterconfig.sh -adapterName userGroupAdapter2 -adapterTemplate adapter_template_usergroup2.xml -host 49 -port 7001 -userName weblogic -domainPath /u01/