In DB : Choose the base or schema of the Temp Table (Security failure)

[dataprep]

Hello,

Here a use case :

I work on the projects A and B with Alteryx inj IN DB mode.

My coworker works only on project B and have no rights to the data of project A.

When using temporary table in Alteryx, we both create the temporary tables in the default database. The issue is my coworker can see my temporary data of project A, which is not safe.

Solution : allow me to specify the database/schema when I create my temporary table.

[Atabarezz]

+1 this is a HUGE issue...

[krysten]

+10000

We restrict the public schema to all users and only DBAs - so I can't even create temp tables when using data stream in. 

[bbartlett]

Agreed, having to grant an Oracle user the 'CREATE ANY TABLE' System Privilege is way too much power.

[simonaubert_bd]

One of the biggest issues for Alteryx in-db, .

Turnarounds we found (not satisfying) :

-an odbc connection and a in-db connection  by user right profile, the temp base/schema being set in the odbc

-prohibit the usage of temp tables

[Kevin_VANCAPPEL]

+1000