It's all about the answers!

Ask a question

RTC 3.0: Required privileges for Oracle DB user


Martin Erzberger (131199) | asked Nov 19 '10, 7:08 a.m.
This http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp?topic=/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html note from RTC 2 outlines the following privileges required for the Oracle user:
GRANT CREATE SESSION TO jazzDBuser;
GRANT CREATE TABLE, ALTER ANY TABLE, DROP ANY TABLE, CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX TO jazzDBuser;
GRANT INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO jazzDBuser;
GRANT CREATE PROCEDURE TO jazzDBuser;
GRANT CREATE VIEW TO jazzDBuser;

This link http://jazz.net/help-dev/rational-team-concert/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_oracle.html only mentions
GRANT CREATE PROCEDURE, CREATE SESSION, CREATE TABLE, CREATE VIEW TO <jazz>;

Which one is correct?

The "ANY" privileges are an absolute no-go in a commercial / professional environment, so I hope the note from RTC 3 is correct.

Thanks! Martin

One answer



permanent link
Martin Erzberger (131199) | answered Nov 19 '10, 7:41 a.m.
To answer my own question: I found a number of Work Items about this topic (e.g. 94866, 123755). Some are for older RTC versions, some for 3.x.
It appears that for RTC 3.0 the instructions are correct. I'll know next week when I try to set-up RTC 3.0

Best regards, Martin

Your answer


Register or to post your answer.