setup ords as dba account
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Fri, 9 Oct 2020 08:12:02 -0700
Message-ID: <CAKsxbLqcBN4_5FLrpQ76cNC6qObumbeK-1_HtEZQOqSZ_=Ve4g_at_mail.gmail.com>
We are new to using ORDS. We like to run everything using scripts, the developers will generate all their updates callable by a single script and I run them into production. However I noticed that will ORDS you have to log in as the schema you want the ORDS service to run as to create it. Is there some other way possible that I can stay logged in as my DBA account but create the service under another schema? And how come there is no DBA_ORDS_% tables, only USER_ORDS_%? I was thinking of putting services in multiple schemas as we have a single database that runs many applications. Or are majority of people putting all their ORDS calls under a single master schema?
Date: Fri, 9 Oct 2020 08:12:02 -0700
Message-ID: <CAKsxbLqcBN4_5FLrpQ76cNC6qObumbeK-1_HtEZQOqSZ_=Ve4g_at_mail.gmail.com>
We are new to using ORDS. We like to run everything using scripts, the developers will generate all their updates callable by a single script and I run them into production. However I noticed that will ORDS you have to log in as the schema you want the ORDS service to run as to create it. Is there some other way possible that I can stay logged in as my DBA account but create the service under another schema? And how come there is no DBA_ORDS_% tables, only USER_ORDS_%? I was thinking of putting services in multiple schemas as we have a single database that runs many applications. Or are majority of people putting all their ORDS calls under a single master schema?
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 09 2020 - 17:12:02 CEST