Request list of DB tables RAM dynamically creates during operation
Can a list be provided of the database tables that RAM dynamically creates in the RAM and RTC data base during RAM operations. The list is needed to restrict the permissions on the database user ids that are assigned to the Oracle RAM and RTC schemas to only those tables that are used and created by the system including all the dynamic tables created abnd destroyed. Is the list of tables that are provided in the RAM configuration from the RAM server setup application all database files that RAM uses with the RAM and RTC databases or are there a set of dynamically created tables?
One answer
In regular operation, RAM does not create or change DB schema of RAM or RTC DBs.
During installation of a new version (and iFixes sometimes), server setup may modify tables/content during migration.
The modified tables really depends on the changes in that release. So during normal operation, no need for schema change permissions. ... you will need them during migration.
During installation of a new version (and iFixes sometimes), server setup may modify tables/content during migration.
The modified tables really depends on the changes in that release. So during normal operation, no need for schema change permissions. ... you will need them during migration.