cerberustesting
Request views for public access to Cerberus
Hi.
For usage of an external application that needs to access data inside Cerberus, I need that a public view is created for the tables described below.
All columns on view can be named as pub_ + base column name (as a suggestion) and public view can also be named as pub_ + base table name.
Here are the tables and columns (for each one) that I need:
For invariant table:
invariant.idname
invariant.value
invariant.sort
invariant.description
invariant.VeryShortDesc
invariant.gp1
For countryenvparam table:
countryenvparam.system
countryenvparam.Country
countryenvparam.Environment
countryenvparam.Build
countryenvparam.Revision
countryenvparam.active
For countryenvironmentparameters table:
countryenvironmentparameters.system
countryenvironmentparameters.Country
countryenvironmentparameters.Environment
countryenvironmentparameters.Application
countryenvironmentparameters.IP
countryenvironmentparameters.domain
countryenvironmentparameters.URL
countryenvironmentparameters.URLLOGIN
For application table:
application.Application
application.description
application.sort
application.type
application.System
application.SubSystem
application.deploytype
