It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,882

question asked: Nov 19 '10, 7:08 a.m.
question was seen: 3,797 times
last updated: Nov 19 '10, 7:08 a.m.

Related questions

RTC 3.0: Required privileges for Oracle DB user

0
Martin Erzberger (131●19●9) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Martin Erzberger (131●19●9) | 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.


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.