Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

oracle db user privilages for CLM 502 version

I am in process of upgrading the CLM from 403 to 502 with Oracle db. I have one question about Oracle user. What privileges we need to have for oracle user for upgrade because I see some tables were altering , updating the schema and then creating the tables while doing the upgrade.

ex: Existing environment have 3 different oracle users for each applications those are jazzjtsuser, jazzccmuser and jazzqmuser so what privileges should have for these 3 users while we are upgrading it?

JDBC connection :

thin:jazzjtsuser/{password}@//lcoalhost:1521/RATDB
thin:jazzccmuser/{password}@//lcoalhost:1521/RATDB
thin:jazzqmuser/{password}@//lcoalhost:1521/RATDB


Thanks in advance for help on it.

0 votes


Accepted answer

Permanent link
 Hi Naveen,

The following info center under step #3 states: The Oracle database user must be able to create database objects in its tablespace (either unlimited or with a space quota) with privileges to create session, table, procedure, and views.

http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html?lang=en

Hope this will help,

Susan
Naveen V selected this answer as the correct answer

0 votes

Comments

I agree with Susan. The privileges for upgrade should be no different than for installation and may even be less.,

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,514
× 2,358
× 1,381

Question asked: Nov 10 '15, 3:11 p.m.

Question was seen: 3,638 times

Last updated: Nov 12 '15, 10:24 p.m.

Confirmation Cancel Confirm