Posted: 18 Jun 2015 2:43 EDT Last activity: 26 Jun 2015 9:33 EDT
Different tables which gets updated when we run BIX Extract from a command line
We are running BIX extract using command line from a .sh file. We were earlier using the DB user which is being used by application server. Due to some reasons, we were asked not to use that user any more and we have to give requirements to DBA.
Can anyone help me identify what all tables will get updated when we run BIX extract using command line.
We are using 7.1.6 for some applications and 7.1.7 for few.
Thanks for your response. The links which were provided are very informative.
I was looking for what are the different PRPC tables on which there will be insert/delete operations will be performed other than pr_extract_time table. When we run BIX extract using command line. The reason I want this information is I would like to know if there would be any deadlock kind of a situation when I use a different DB user (other than the one which is configured in my applicaiton server) and run the extract.
When we run BIX, it won't perform any insert/delete operations on tables. BIX will issue a select command to fetch data. Apart from pr_extract_time table few log related tables will be affected like pr_log_usage.
I agree, that is what is understood. But, when we have created a DB user who got only read only privileges on all the tables in DATA and RULES schema and insert privileges for pr_extract_time table, we were getting below errors. Which clearly shows BIX requires INSERT & DELETE & UPDATE privileges apart from SELECT privileges on many tables. We havent tried to discover the number of tables on which these kind of operations are performed. Instead we have given the above privileges on all the tables in DATA and RULES schema. Not only these operations. BIX even demands EXECUTE privileges on to certain stored procs that comes with the product.
When you run BIX from command line, first BIX will connect to PRPC database and make the server up for which it will connect to basic prpc tables which are required for starting the server.
During the extarct also, BIX needs to update some basic tables like system lock tables, cache tables ,log usage tables etc. This is internal to PRPC OOTB tables .
Regardless of the option you choose, as the user connecting to the database, you must be granted the CONNECT role and have INSERT, SELECT, UPDATE, and DELETE object privileges for all tables and views and the EXECUTE object privilege for functions and procedures.