Can you define which DB user a script has to be run by?

We are using Stat 6.1.0 with Oracle EBS. Our connections for our environments are setup as the APPS user. Is it possible to define a certain script or object type to connect as a different DB user without setting up new environments/workflows ?



  • Hi Johnnie,  

    For objects that are defined with "Database Script" checked, you can edit the archive set, click on the "Objects" tab and modify the "Generation Schema" column and change it to the needed schema. Also the apps user can create objects in other schemas, we use Stat that way.  For instance, you can create a table in your custom schema with "create table xxx.new_table .....  " or " create index index".  

    Hope this helps.

    Tom Shaw