Database management

Secure Your Oracle Database: Authentication and Access Controls

Corporate information is a critical differentiator for organizations and their customers.  Financial intelligence, personally identifiable information (PII), trade secrets and other proprietary information are common forms of data stored in databases. In order to protect this information from internal and external misuse or attack, businesses must implement security measures as close to the data as […]

Database management

Best Practices: Secure Oracle Configuration and Database Auditing

In our last post, we shared the 4 most important areas of database security and discussed how to safeguard your Oracle environment with best practices for Authentication and Access Controls. In this post, we continue with a breakdown of Oracle database security best practices for Secure Oracle Configuration and Database Auditing. Secure Oracle Configuration Secure Listener Configuration Listener authentication should be local OS user. Implement […]

Database management

Data Warehousing Documentation Requirements

One of the most frequently asked questions when starting a Data Warehousing initiative is: “What best practices should I be following?” In this series of posts, we will outline our recommendations to follow when building a data warehouse – starting with data warehousing documentation. Data Warehousing Best Practice: Documentation  A successful data warehouse implementation boils down to […]

Database management

Oracle RMAN Myth Busting

Background: Database Administration ChallengesManaging Oracle database backup and recovery is a critical operational requirement for database administrators (DBAs). With increasing database sizes and Service Level Agreements (some requiring 24×7-database availability), DBAs need to effectively design and manage data protection solutions to minimize performance impact on production databases. Below are key operational goals that DBAs need […]