I was worried as I ran into a problem with the Database Vault security. I configured a new realm in a database where the Oracle E-Business Suite is running. The main idea was to have a user for the OBIEE that should have only limited access. Together with some colleagues we made sure that the OBIEE user had the correct grants on some tables and views inside the EBS schema (APPS, AR, GMS, PA). I created the realm and added the OBIEE user as a participant. Everything seemed to work. Then I disabled the realm and even removed the OBIEE user from the realm, but still Oracle Answers was capable of accessing the APPS schema objects. Took me a day and finally I reread the manual. I understood my error. The purpose of the DBV is to lockout users with system privileges, such as the SYS or SYSTEM user. Now the account of the OBIEE user does not have these system privileges except CREATE SESSION. In order to access any object the OBIEE user relies on discretionary grants (e.g. the AR user grants ...
Some of the stuff I do for a living. This mainly concerns working with Oracle Databases and Application Servers. Lately I picked up AWS, Azure and OCI.