Hi All,
Currently we have one database in which there is currently one schema say with country A. To access the different table data from GUI we have user (say gui_user), which access these table using synonyms which have been created.
Problem: Going forward for the same database we are going to create another schema B for different county with same tables & table names as schema A.
1) is it possible to create the table synonyms for schema B with same table so that gui_user can access the country specific tables A or B.
or have one same synonym pointing to different tables in sachems but can switch based on the location on runtime.
2) How to we switch between the schema so that the gui_user can point to the correct country,
Thanks