Welcome to the Jazz Community Forum
RPTUSER on Oracle
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?
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
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
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
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
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:The Custom Report Database User (RPTUSER) is the database user used by RRDI and Rational Insight to read data from the Data Warehouse.This user must already exist in the database. None of the he Data Warehouse setup scripts will create the user.
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.
In this information center, it doesn't guide that we should create "RPTUSER" before executing setup wizard.
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html
Sorry for ask this again, but RPTUSER MUST be created beforehand? Or does setup wizard create it for me?
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?
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?