It's all about the answers!

Ask a question

BBDD setup user permissions


Ismael Serrano Hidalgo (342812) | asked Jul 27 '15, 5:30 a.m.
 Hi,

In order to create the BBDD data model for QM and JTS in DB2, it is needed to do it through an admin user or an user with DBADM permissions. 
I just need to know the exact operations for both the installation process (the setup) and ongoing operations once RQM is up&running. I mean, i.e. create table, insert, update...
I have to deploy RQM in a customer very estrict in terms of security, and requires to adjust the permissions task by task in terms of BBDD, instead of giving DBADM permissions to the user...

Thanks very much in advance.

Regards,
ISMAEL

One answer



permanent link
Antoinette Iacobo (650712) | answered Jul 27 '15, 9:56 a.m.
 Hi Ismael,

I don't know of any existing documentation for this, only for the data warehouse scripts: https://jazz.net/wiki/bin/view/Main/MoreControlOverTheDB2DataWarehouseSetup

But perhaps what you could do is consult with the DB2 DBA and test out repotools-qm and -jts createTables command with a DB2 sql monitoring tool (you could identify the client by the user connected via the teamserver.properties file) like this: http://www.ibm.com/developerworks/data/library/techarticle/dm-1401sqltrace/

Toni

Comments
Ismael Serrano Hidalgo commented Jul 27 '15, 10:20 a.m.

Thanks very much Toni. Very good approach! 

I will try it in my testing environment, and write down the results...

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.