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

RTC 3.0: Required privileges for Oracle DB user

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

0 votes



One answer

Permanent link
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

0 votes

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

Question asked: Nov 19 '10, 7:08 a.m.

Question was seen: 3,824 times

Last updated: Nov 19 '10, 7:08 a.m.

Confirmation Cancel Confirm