My Oracle Support Banner

Visual Builder FAQ - Queries On Tenant Database Configuration (Doc ID 2711424.1)

Last updated on MAY 10, 2021

Applies to:

Visual Builder Studio - Version 19.4.3 and later
Information in this document applies to any platform.

Purpose

 Common queries on VB Tenant Database Configuration

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
  Q1.  After switching to the appropriate database, how will the data be stored and accessed? Will it store the data based on the Stage, Dev, and Live mode or only one set of data?
Please provide relevant links for further reading.
 Q2.  After switching to the database, can I remove the tenant database and use the embedded database back in VB?
 Q3. After configuring the tenant database, as you mentioned there will be separate schemas created for Dev, Stage, and Live.  Will these custom schemas be accessible only from Admin or SYS user ?
 Is there any way that we can connect to that custom schema individually and provide access to this schema for other systems so that they can load the data and the same data can be used in VBCS UI. 
 Q4.   After having custom PL/SQL code in the database, can I access it inside in the VBCS application? Is that possible? Please share an example if possible.
 Q5.  Can I provide grants from Schema A to VBCSDEV schema and is it possible to access those objects in VB?
 Q6.  Once the tenant database is configured successfully then the custom schemas are created at runtime are like - VB_VB_xxxxxxxxxxx, VB_VB_yyyyyyyyyyy, VB_VB_zzzzzzzzzzz. These custom schemas are actually for only one application but created for DEV, Stage, and Live.  I was able to query the data from these schemas using the SYS user.  But, is there any possibility that we can connect to these VB schemas by the standard way of connecting to Database schemas, e.g: by providing a username and password?  If possible, please provide the steps.
Note - I am able to access these schemas from SYS schema and the underlying BOs are also accessible.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.