Global Temporary Table - Analysis 116

[jduke99]

I'm getting an error on Analysis 116 as follows:

Error:
execute JDBC update query failed in dbSendUpdate (ORA-01031: insufficient privileges
)

SQL:
CREATE TEMPORARY TABLE temp_dates
ON COMMIT PRESERVE ROWS
AS
SELECT
distinct
EXTRACT(YEAR FROM observation_period_start_date) as obs_year

FROM

OBSERVATION_PERIOD

I think it is trying to create the temp table on the CDM4 schema rather than on my Results schema. I have don't have permissions to create tables on the CDM4 database, but of course can create on the Results database.

Can you change code for 116 (and any others than use temp tables) to make the table on @results_schema.dbo.[table] so that a user does not require CREATE privileges on their CDM to run the analysis?

[schuemie]

Done. All temp files are now created in the results schema.