RPTUSER on Oracle
![]()
Yohko Tanaka (105●2●32●39)
| asked Oct 09 '13, 7:05 a.m.
edited Oct 21 '13, 4:11 p.m. by Douglas Bush (281●2●5)
When setting up Oracle for CLM, does RPTUSER need to be created in advance?
If so, where this user should be created? In this infocenter, it says "Note: For Oracle: An OS level user is not required. The report user must have access to the data warehouse." http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.rrdi.admin.doc/topics/t_configure_datasource_conn_dw.html Do I need to create oracle user (named RPTUSER) before doing setup wizard? Or setup wizard create RPTUSER during setup? |
Accepted answer
![]()
Hello Yokho,
the RPTUSER must be created before running the setup wizard. Some references are in this info center section: Creating a reporting user account for connecting to the data warehouse http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.rational.rrdi.admin.doc/topics/t_configure_datasource_conn_dw.html Best Regards Francesco Yohko Tanaka selected this answer as the correct answer
|
3 other answers
![]()
Hello Yokho,
according to the jazz wiki entry: More Control over the Oracle Data Warehouse Setup https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup You can create the RPTUSER with commands similar to these, when connected to the data warehouse from sqlplus: CREATE USER RPTUSER IDENTIFIED BY [Password] DEFAULT TABLESPACE [Your DW tablespace] QUOTA UNLIMITED ON [Your DW tablespace] TEMPORARY TABLESPACE RIS_TEMP; GRANT CONNECT, CREATE SESSION TO RPTUSER; Best Regards Francesco Comments Thank you for the reply.
|
![]()
Hi, I have another question.
How do I change password for RPTUSER? My customer requires changing password of Oracle users on a regular basis. When the password of RPTUSER is changed in a oracle, how do I set the new password in CLM? I found Insight's information center, but I didn't configure Insight. ( I configured only RTC/RQM/RRC) http://pic.dhe.ibm.com/infocenter/rentrpt/v1r0m1/topic/com.ibm.rational.raer.deploying.doc/topics/t_change_pwd_for_rptuser.html I also check "advanced property" of /jts/admin. I found "RPTUSER" in "Custome Report Database user" section, but it seems there is no "password" section for RPTUSER. Does anybody know how to change RPTUSER's password? |
![]()
Hello Yohko,
to my understanding the RPTUSER is not used within CLM, so there's no need to change the password. Best Regards Francesco |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.