# Oracle E-Business Suite and Oracle 12c Security

- URL: https://www.integrigy.com/security-resources/oracle-e-business-suite-and-oracle-12c-security
- Published: 2014-12-19
- Type: Webinar
- Products: Oracle E-Business Suite, Oracle Database
- Focus areas: Auditing, Encryption
- Applies to: EBS 12.1, DB 12c
- PDF: https://www.integrigy.com/sites/default/files/Integrigy%20New%20Oracle%2012c%20Security%20Features%20Oracle%20EBS.pdf
- Recording: https://www.youtube.com/watch?v=bHDhHmVI8Pw

> Webinar on the Oracle 12c Database security features for Oracle E-Business Suite users: data redaction, auditing, encryption, SYSDBA separation of duties, last-login tracking and password complexity.

Oracle Database 12c, certified with Oracle E-Business Suite as of September 2014, delivers several new security features of value to EBS professionals who need to meet security and compliance requirements. We review them in the context of our EBS security best practices: data redaction, auditing and encryption key management, along with new features for SYSDBA segregation of duties, tracking database last logins, enforcing password complexity and granting read-only object privileges.

We also cover the security steps when upgrading the EBS database to 12c, which our [upgrade security notes](https://www.integrigy.com/oracle-security-blog/oracle-e-business-suite-database-12c-upgrade-security-notes) describe in more detail. EBS DBAs and security teams can then decide which 12c features to use with EBS and where not to.

## Key Points

- When upgrading EBS 12.0 or 12.1 to 12c with Oracle Support Note ID 1524398.1, apply the latest CPU (step 8), since upgrades include only the CPUs available at their release, re-enable Database Vault, disabled for the upgrade (step 11), drop the unused DMSYS schema (step 15) and review security-related initialization parameters (step 16); these releases are now desupported.
- Alongside SYSDBA, 12c adds SYSBACKUP for RMAN, SYSDG for Data Guard and SYSKM for managing TDE encryption keys, so junior DBAs can run backups without a highly privileged account and staff other than DBAs can manage keys, and the hidden parameter `_sys_logon_delay` adds brute-force protection to SYS and the other password file users.
- Passwords are now case sensitive by default, with a stronger hash and new password verify functions, `SYS.DBA_USERS` gains a `LAST_LOGIN` column for account management and auditing, and the new `READ` object privilege allows queries without the row locking `SELECT` permits, though `GRANT ALL PRIVILEGES` now also grants `READ ANY TABLE`.
- Database Vault is now pre-installed, with pre-built realms for EBS, but needs an additional license, and APEX is now mandatory and cannot be uninstalled, so secure any APEX integration with EBS and disable the embedded APEX listener if you don't use it.
- Oracle Data Redaction, part of the separately licensed Advanced Security Option and certified with EBS, redacts columns at query time but isn't enforced for SYSDBA and doesn't stop ad-hoc queries, so use it for reporting outside EBS, such as through OBIEE or BI Publisher, not within EBS or against DBAs, and mask non-production data instead.
- 12c's mandatory auditing always audits SYS, SYSDBA and the other administrative privileges and changes to audit settings, and for EBS we recommended Mixed Mode, the default, where traditional auditing, which Oracle desupported in 23ai (now 26ai) in favor of Unified Auditing, still works, with reports from `SYS.UNIFIED_AUDIT_TRAIL` and the `ORA_SECURECONFIG` policy disabled or purged (Doc ID 1624051.1).
