Hi, I am trying to set Oracle database (instead of HSQL) as the default database to store data regarding my reports. I am using a login ID which has permissions to create table. But I am getting an error "In creating database it has not enough privilege, please modify the privilege for this user". PFA screen shot of the same. Does the user login ID require permissions to create database? Does this mean the information will be stored within a new schema in the Oracle database? Please let me know what other privileges the user ID needs to have to accomplish the above successfully. Thanks! Mythili
No, TDQ will not create a new schema. You must enter an existing schema name in which you want to see the tables in the preference page. You may create a user called "tdq" and the tables and views will be created in this schema if the user "hr" has the appropriate permissions.
Sebastiao,
We grated the 3 privileges mentioned above to our functional ID and now we are able to use Oracle as the reporting DB. Thank You!
Is there any document which can give us more details regarding the way the data is stored in the multiple TDQ_* tables which are now created in Oracle? This would throw some light on what can be expected in the various tables and how effectively we can utilize that data.
Thanks!
Mythili
Sebastiao,
I have another follow-up question on this thread, once the datamart structure is initialized then can we drop the elevated privileges given to user ID (CSMARTVOL) i.e. drop
"create any table"
"unlimited tablespace"
And go back to original privileges? Please refer to link below for the original privileges
http://www.talendforge.org/forum/postgallery.php?pid=55640&filename=roles_and_privileges.JPG Thanks,
-Arun
