It's all about the answers!

Ask a question

oracle db user privilages for CLM 502 version

Naveen V (79851) | asked Nov 10 '15, 3:11 p.m.
edited Nov 12 '15, 10:24 p.m. by Lisa Frankel (5462)
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 :


Thanks in advance for help on it.

Accepted answer

permanent link
Susan Wu (4711916) | answered Nov 10 '15, 5:05 p.m.
 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.

Hope this will help,

Naveen V selected this answer as the correct answer

Rosa Naranjo commented Nov 10 '15, 5:29 p.m.

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

Your answer

Register or to post your answer.