How to remove the temporary schema generation

raghuvr76 · Participant Joined: 27 Jul 2010 Posts: 9 Points: 57

Hi Guys,
Anyone know about how to remove the temporary schema generation in IBM INFOSPHERE WAREHOUSE 9.7. I am getting an error as "you does not have privilege to create schema".

Thanks

ray.wurlod · Posted: Mon Oct 25, 2010 8:51 am

Wouldn't it make more sense to execute as a user who does have the requisite database privileges?

raghuvr76 · Participant Joined: 27 Jul 2010 Posts: 9 Points: 57

ya eventhough the user who has the privilege,everytime the schemas are generating and he got to remove them right instead of that if we select the option of not generating the schemas then it wouldn't be a problem.

Thanks.