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 |
One answer
![]()
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
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.