Pau Lo
asked on
oracle BI database security benefits
We have an oracle EBS (financials) database and the data is copied to the BI database for reporting. From a security angle, we did some checks for weak and default passwords in the EBS, and the exact same issues were found in the BI database, For anyone familiar with BI, does it just copy the entire database including user accounts and passwords. And if so is there any value locking down the passwords in the BI database, if they will be just overwritten constantly by the EBS data when it is reimported?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BI database is (or should be a datamart/data warehouse) that supports OLAP (OnLine Analytical Processing) and is used for reporting and analyzing data.
Typically it has a special architecture (schemas) which data is fed from the transactional database.
Therefore just duplicating the source database would not fulfill the requirements of BI -- which is the issue here.
What I am stating is purely a generic overview.
PS: Typically there is a second layer of security provided by the software used to exploit the BI database.
Typically it has a special architecture (schemas) which data is fed from the transactional database.
Therefore just duplicating the source database would not fulfill the requirements of BI -- which is the issue here.
What I am stating is purely a generic overview.
PS: Typically there is a second layer of security provided by the software used to exploit the BI database.
ASKER
can you elaborate?
thanks for the feedback