Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Wednesday, March 20, 2019
For Single Application .. Multiple Schema
You Can Use API
--Shared Component
---Security Attribute
-----Database Session
-------Initialization PL/SQL Code
DECLARE
BEGIN
IF UPPER(:APP_USER) = 'A' THEN
APEX_UTIL.SET_PARSING_SCHEMA_FOR_REQUEST
( P_SCHEMA => 'HR_A');
ELSE
APEX_UTIL.SET_PARSING_SCHEMA_FOR_REQUEST
( P_SCHEMA => 'HR_B');
END IF;
END;
can we cross over the pdb ?
ReplyDelete