Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpsg\target.db
<?xml version="1.0" encoding="UTF-8"?> <div element="book" href="toc.htm" number="" targetptr=""> <ttl>Oracle Database 2 Day + Security Guide</ttl> <xreftext><cite> Oracle Database 2 Day + Security Guide</cite></xreftext> <div element="chapter" href="tdpsg_intro.htm" number="1" targetptr="TDPSG94426"> <ttl>Introduction to Oracle Database Security</ttl> <xreftext>“Introduction to Oracle Database Security”</xreftext> <div element="sect1" href="tdpsg_intro001.htm" number="1.1" targetptr="TDPSG10016"> <ttl>About Making an Oracle Database Highly Secure</ttl> <xreftext>“About Making an Oracle Database Highly Secure”</xreftext> </div> <div element="sect1" href="tdpsg_intro002.htm" number="1.2" targetptr="TDPSG10013"> <ttl>Common Database Security Tasks</ttl> <xreftext>“Common Database Security Tasks”</xreftext> </div> <div element="sect1" href="tdpsg_intro003.htm" number="1.3" targetptr="TDPSG10014"> <ttl>Tools for Securing Your Database</ttl> <xreftext>“Tools for Securing Your Database”</xreftext> </div> <div element="sect1" href="tdpsg_intro004.htm" number="1.4" targetptr="TDPSG10015"> <ttl>Securing Your Database: A Roadmap</ttl> <xreftext>“Securing Your Database: A Roadmap”</xreftext> </div> </div> <div element="chapter" href="tdpsg_install_config.htm" number="2" targetptr="TDPSG60000"> <ttl>Securing the Database Installation and Configuration</ttl> <xreftext>“Securing the Database Installation and Configuration”</xreftext> <div element="sect1" href="tdpsg_install_config001.htm" number="2.1" targetptr="TDPSG60061"> <ttl>About Securing the Database Installation and Configuration</ttl> <xreftext>“About Securing the Database Installation and Configuration”</xreftext> </div> <div element="sect1" href="tdpsg_install_config002.htm" number="2.2" targetptr="TDPSG60066"> <ttl>Enabling the Default Security Settings</ttl> <xreftext>“Enabling the Default Security Settings”</xreftext> <obj element="table" href="tdpsg_install_config002.htm" number="2-1" targetptr="TDPSG94339"> <ttl>Default Security Settings for Initialization Parameters</ttl> <xreftext>“Default Security Settings for Initialization Parameters”</xreftext> </obj> </div> <div element="sect1" href="tdpsg_install_config003.htm" number="2.3" targetptr="TDPSG60062"> <ttl>Securing the Oracle Data Dictionary</ttl> <xreftext>“Securing the Oracle Data Dictionary”</xreftext> <div element="sect2" href="tdpsg_install_config004.htm" number="2.3.1" targetptr="TDPSG60621"> <ttl>About the Oracle Data Dictionary</ttl> <xreftext>“About the Oracle Data Dictionary”</xreftext> <obj element="example" href="tdpsg_install_config004.htm" number="2-1" targetptr="TDPSG94341"> <ttl>Finding Views That Pertain to the Data Dictionary</ttl> <xreftext>“Finding Views That Pertain to the Data Dictionary”</xreftext> </obj> </div> <div element="sect2" href="tdpsg_install_config005.htm" number="2.3.2" targetptr="TDPSG60622"> <ttl>Enabling Data Dictionary Protection</ttl> <xreftext>“Enabling Data Dictionary Protection”</xreftext> </div> </div> <div element="sect1" href="tdpsg_install_config006.htm" number="2.4" targetptr="TDPSG60063"> <ttl>Guidelines for Securing Operating System Access to Oracle Database</ttl> <xreftext>“Guidelines for Securing Operating System Access to Oracle Database”</xreftext> </div> <div element="sect1" href="tdpsg_install_config007.htm" number="2.5" targetptr="TDPSG60064"> <ttl>Guideline for Granting Permissions to Run-Time Facilities</ttl> <xreftext>“Guideline for Granting Permissions to Run-Time Facilities”</xreftext> </div> <div element="sect1" href="tdpsg_install_config008.htm" number="2.6" targetptr="TDPSG60065"> <ttl>Initialization Parameters Used for Installation and Configuration Security</ttl> <xreftext>“Initialization Parameters Used for Installation and Configuration Security”</xreftext> <obj element="table" href="tdpsg_install_config008.htm" number="2-2" targetptr="TDPSG94343"> <ttl>Initialization Parameters Used for Installation and Configuration Security</ttl> <xreftext>“Initialization Parameters Used for Installation and Configuration Security”</xreftext> </obj> <div element="sect2" href="tdpsg_install_config009.htm" number="2.6.1" targetptr="TDPSG60651"> <ttl>Modifying the Value of an Initialization Parameter</ttl> <xreftext>“Modifying the Value of an Initialization Parameter”</xreftext> </div> </div> </div> <div element="chapter" href="tdpsg_user_accounts.htm" number="3" targetptr="TDPSG20000"> <ttl>Securing Oracle Database User Accounts</ttl> <xreftext>“Securing Oracle Database User Accounts”</xreftext> <div element="sect1" href="tdpsg_user_accounts001.htm" number="3.1" targetptr="TDPSG20021"> <ttl>About Securing Oracle Database User Accounts</ttl> <xreftext>“About Securing Oracle Database User Accounts”</xreftext> </div> <div element="sect1" href="tdpsg_user_accounts002.htm" number="3.2" targetptr="TDPSG20030"> <ttl>Predefined User Accounts Provided by Oracle Database</ttl> <xreftext>“Predefined User Accounts Provided by Oracle Database”</xreftext> <div element="sect2" href="tdpsg_user_accounts003.htm" number="3.2.1" targetptr="TDPSG20301"> <ttl>Predefined Administrative Accounts</ttl> <xreftext>“Predefined Administrative Accounts”</xreftext> <obj element="table" href="tdpsg_user_accounts003.htm" number="3-1" targetptr="TDPSG94345"> <ttl>Predefined Oracle Database Administrative User Accounts</ttl> <xreftext>“Predefined Oracle Database Administrative User Accounts”</xreftext> </obj> </div> <div element="sect2" href="tdpsg_user_accounts004.htm" number="3.2.2" targetptr="TDPSG20302"> <ttl>Predefined Non-Administrative User Accounts</ttl> <xreftext>“Predefined Non-Administrative User Accounts”</xreftext> <obj element="table" href="tdpsg_user_accounts004.htm" number="3-2" targetptr="TDPSG94346"> <ttl>Predefined Oracle Database Non-Administrative User Accounts</ttl> <xreftext>“Predefined Oracle Database Non-Administrative User Accounts”</xreftext> </obj> </div> <div element="sect2" href="tdpsg_user_accounts005.htm" number="3.2.3" targetptr="TDPSG20303"> <ttl>Predefined Sample Schema User Accounts</ttl> <xreftext>“Predefined Sample Schema User Accounts”</xreftext> <obj element="table" href="tdpsg_user_accounts005.htm" number="3-3" targetptr="TDPSG94347"> <ttl>Default Sample Schema User Accounts</ttl> <xreftext>“Default Sample Schema User Accounts”</xreftext> </obj> </div> </div> <div element="sect1" href="tdpsg_user_accounts006.htm" number="3.3" targetptr="TDPSG20024"> <ttl>Expiring and Locking Database Accounts</ttl> <xreftext>“Expiring and Locking Database Accounts”</xreftext> </div> <div element="sect1" href="tdpsg_user_accounts007.htm" number="3.4" targetptr="TDPSG20022"> <ttl>Requirements for Creating Passwords</ttl> <xreftext>“Requirements for Creating Passwords”</xreftext> </div> <div element="sect1" href="tdpsg_user_accounts008.htm" number="3.5" targetptr="TDPSG20023"> <ttl>Finding and Changing Default Passwords</ttl> <xreftext>“Finding and Changing Default Passwords”</xreftext> </div> <div element="sect1" href="tdpsg_user_accounts009.htm" number="3.6" targetptr="TDPSG20025"> <ttl>Guideline for Handling the Default Administrative User Passwords</ttl> <xreftext>“Guideline for Handling the Default Administrative User Passwords”</xreftext> </div> <div element="sect1" href="tdpsg_user_accounts010.htm" number="3.7" targetptr="TDPSG20027"> <ttl>Guideline for Enforcing Password Management</ttl> <xreftext>“Guideline for Enforcing Password Management”</xreftext> </div> <div element="sect1" href="tdpsg_user_accounts011.htm" number="3.8" targetptr="TDPSG20029"> <ttl>Parameters Used to Secure User Accounts</ttl> <xreftext>“Parameters Used to Secure User Accounts”</xreftext> <obj element="table" href="tdpsg_user_accounts011.htm" number="3-4" targetptr="TDPSG94351"> <ttl>Initialization and Profile Parameters Used for User Account Security</ttl> <xreftext>“Initialization and Profile Parameters Used for User Account Security”</xreftext> </obj> </div> </div> <div element="chapter" href="tdpsg_privileges.htm" number="4" targetptr="TDPSG30000"> <ttl>Managing User Privileges</ttl> <xreftext>“Managing User Privileges”</xreftext> <div element="sect1" href="tdpsg_privileges001.htm" number="4.1" targetptr="TDPSG30031"> <ttl>About Privilege Management</ttl> <xreftext>“About Privilege Management”</xreftext> </div> <div element="sect1" href="tdpsg_privileges002.htm" number="4.2" targetptr="TDPSG30033"> <ttl>Guideline for Granting Privileges</ttl> <xreftext>“Guideline for Granting Privileges”</xreftext> </div> <div element="sect1" href="tdpsg_privileges003.htm" number="4.3" targetptr="TDPSG30038"> <ttl>Guideline for Granting Roles to Users</ttl> <xreftext>“Guideline for Granting Roles to Users”</xreftext> </div> <div element="sect1" href="tdpsg_privileges004.htm" number="4.4" targetptr="TDPSG30034"> <ttl>Guideline for Handling Privileges for the PUBLIC User Group</ttl> <xreftext>“Guideline for Handling Privileges for the PUBLIC User Group”</xreftext> </div> <div element="sect1" href="tdpsg_privileges005.htm" number="4.5" targetptr="TDPSG30032"> <ttl>Controlling Access to Applications with Secure Application Roles</ttl> <xreftext>“Controlling Access to Applications with Secure Application Roles”</xreftext> <div element="sect2" href="tdpsg_privileges006.htm" number="4.5.1" targetptr="TDPSG30321"> <ttl>About Secure Application Roles</ttl> <xreftext>“About Secure Application Roles”</xreftext> </div> <div element="sect2" href="tdpsg_privileges007.htm" number="4.5.2" targetptr="TDPSG30323"> <ttl>Tutorial: Creating a Secure Application Role</ttl> <xreftext>“Tutorial: Creating a Secure Application Role”</xreftext> <div element="sect3" href="tdpsg_privileges008.htm" number="4.5.2.1" targetptr="TDPSG33231"> <ttl>Step 1: Create a Security Administrator Account</ttl> <xreftext>“Step 1: Create a Security Administrator Account”</xreftext> </div> <div element="sect3" href="tdpsg_privileges009.htm" number="4.5.2.2" targetptr="TDPSG33232"> <ttl>Step 2: Create User Accounts for This Tutorial</ttl> <xreftext>“Step 2: Create User Accounts for This Tutorial”</xreftext> </div> <div element="sect3" href="tdpsg_privileges010.htm" number="4.5.2.3" targetptr="TDPSG33233"> <ttl>Step 3: Create the Secure Application Role</ttl> <xreftext>“Step 3: Create the Secure Application Role”</xreftext> </div> <div element="sect3" href="tdpsg_privileges011.htm" number="4.5.2.4" targetptr="TDPSG33234"> <ttl>Step 4: Create a Lookup View</ttl> <xreftext>“Step 4: Create a Lookup View”</xreftext> </div> <div element="sect3" href="tdpsg_privileges012.htm" number="4.5.2.5" targetptr="TDPSG33238"> <ttl>Step 5: Create the PL/SQL Procedure to Set the Secure Application Role</ttl> <xreftext>“Step 5: Create the PL/SQL Procedure to Set the Secure Application Role”</xreftext> </div> <div element="sect3" href="tdpsg_privileges013.htm" number="4.5.2.6" targetptr="TDPSG33235"> <ttl>Step 6: Grant EXECUTE Privileges for the Procedure to Matthew and Winston</ttl> <xreftext>“Step 6: Grant EXECUTE Privileges for the Procedure to Matthew and Winston”</xreftext> </div> <div element="sect3" href="tdpsg_privileges014.htm" number="4.5.2.7" targetptr="TDPSG33236"> <ttl>Step 7: Test the EMPLOYEE_ROLE Secure Application Role</ttl> <xreftext>“Step 7: Test the EMPLOYEE_ROLE Secure Application Role”</xreftext> </div> <div element="sect3" href="tdpsg_privileges015.htm" number="4.5.2.8" targetptr="TDPSG33237"> <ttl>Step 8: Optionally, Remove the Components for This Tutorial</ttl> <xreftext>“Step 8: Optionally, Remove the Components for This Tutorial”</xreftext> </div> </div> </div> <div element="sect1" href="tdpsg_privileges016.htm" number="4.6" targetptr="TDPSG30036"> <ttl>Initialization Parameters Used for Privilege Security</ttl> <xreftext>“Initialization Parameters Used for Privilege Security”</xreftext> <obj element="table" href="tdpsg_privileges016.htm" number="4-1" targetptr="TDPSG94361"> <ttl>Initialization Parameters Used for Privilege Security</ttl> <xreftext>“Initialization Parameters Used for Privilege Security”</xreftext> </obj> </div> </div> <div element="chapter" href="tdpsg_network_secure.htm" number="5" targetptr="TDPSG90000"> <ttl>Securing the Network</ttl> <xreftext>“Securing the Network”</xreftext> <div element="sect1" href="tdpsg_network_secure001.htm" number="5.1" targetptr="TDPSG90061"> <ttl>About Securing the Network</ttl> <xreftext>“About Securing the Network”</xreftext> </div> <div element="sect1" href="tdpsg_network_secure002.htm" number="5.2" targetptr="TDPSG60067"> <ttl>Securing the Client Connection on the Network</ttl> <xreftext>“Securing the Client Connection on the Network”</xreftext> <div element="sect2" href="tdpsg_network_secure003.htm" number="5.2.1" targetptr="TDPSG60672"> <ttl>Guidelines for Securing Client Connections</ttl> <xreftext>“Guidelines for Securing Client Connections”</xreftext> </div> <div element="sect2" href="tdpsg_network_secure004.htm" number="5.2.2" targetptr="TDPSG60673"> <ttl>Guidelines for Securing the Network Connection</ttl> <xreftext>“Guidelines for Securing the Network Connection”</xreftext> </div> </div> <div element="sect1" href="tdpsg_network_secure005.htm" number="5.3" targetptr="TDPSG40045"> <ttl>Protecting Data on the Network by Using Network Encryption</ttl> <xreftext>“Protecting Data on the Network by Using Network Encryption”</xreftext> <div element="sect2" href="tdpsg_network_secure006.htm" number="5.3.1" targetptr="TDPSG40451"> <ttl>About Network Encryption</ttl> <xreftext>“About Network Encryption”</xreftext> </div> <div element="sect2" href="tdpsg_network_secure007.htm" number="5.3.2" targetptr="TDPSG40452"> <ttl>Configuring Network Encryption</ttl> <xreftext>“Configuring Network Encryption”</xreftext> </div> </div> <div element="sect1" href="tdpsg_network_secure008.htm" number="5.4" targetptr="TDPSG40046"> <ttl>Initialization Parameters Used for Network Security</ttl> <xreftext>“Initialization Parameters Used for Network Security”</xreftext> <obj element="table" href="tdpsg_network_secure008.htm" number="5-1" targetptr="TDPSG94363"> <ttl>Initialization Parameters Used for Network Security</ttl> <xreftext>“Initialization Parameters Used for Network Security”</xreftext> </obj> </div> </div> <div element="chapter" href="tdpsg_securing_data.htm" number="6" targetptr="TDPSG40000"> <ttl>Securing Data</ttl> <xreftext>“Securing Data”</xreftext> <div element="sect1" href="tdpsg_securing_data001.htm" number="6.1" targetptr="TDPSG30041"> <ttl>About Securing Data</ttl> <xreftext>“About Securing Data”</xreftext> </div> <div element="sect1" href="tdpsg_securing_data002.htm" number="6.2" targetptr="TDPSG40043"> <ttl>Encrypting Data Transparently with Transparent Data Encryption</ttl> <xreftext>“Encrypting Data Transparently with Transparent Data Encryption”</xreftext> <div element="sect2" href="tdpsg_securing_data003.htm" number="6.2.1" targetptr="TDPSG40041"> <ttl>About Encrypting Sensitive Data</ttl> <xreftext>“About Encrypting Sensitive Data”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data004.htm" number="6.2.2" targetptr="TDPSG40042"> <ttl>When Should You Encrypt Data?</ttl> <xreftext>“When Should You Encrypt Data?”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data005.htm" number="6.2.3" targetptr="TDPSG40431"> <ttl>How Transparent Data Encryption Works</ttl> <xreftext>“How Transparent Data Encryption Works”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data006.htm" number="6.2.4" targetptr="TDPSG40432"> <ttl>Configuring Data to Use Transparent Data Encryption</ttl> <xreftext>“Configuring Data to Use Transparent Data Encryption”</xreftext> <div element="sect3" href="tdpsg_securing_data007.htm" number="6.2.4.1" targetptr="TDPSG44321"> <ttl>Step 1: Configure the Wallet Location</ttl> <xreftext>“Step 1: Configure the Wallet Location”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data008.htm" number="6.2.4.2" targetptr="TDPSG44322"> <ttl>Step 2: Create the Wallet</ttl> <xreftext>“Step 2: Create the Wallet”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data009.htm" number="6.2.4.3" targetptr="TDPSG44323"> <ttl>Step 3: Open (or Close) the Wallet</ttl> <xreftext>“Step 3: Open (or Close) the Wallet”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data010.htm" number="6.2.4.4" targetptr="TDPSG44324"> <ttl>Step 4: Encrypt (or Decrypt) Data</ttl> <xreftext>“Step 4: Encrypt (or Decrypt) Data”</xreftext> <div element="sect4" href="tdpsg_securing_data011.htm" number="6.2.4.4.1" targetptr="TDPSG44325"> <ttl>Encrypting Individual Table Columns</ttl> <xreftext>“Encrypting Individual Table Columns”</xreftext> </div> <div element="sect4" href="tdpsg_securing_data012.htm" number="6.2.4.4.2" targetptr="TDPSG44326"> <ttl>Encrypting a Tablespace</ttl> <xreftext>“Encrypting a Tablespace”</xreftext> </div> </div> </div> <div element="sect2" href="tdpsg_securing_data013.htm" number="6.2.5" targetptr="TDPSG40433"> <ttl>Checking Existing Encrypted Data</ttl> <xreftext>“Checking Existing Encrypted Data”</xreftext> <div element="sect3" href="tdpsg_securing_data014.htm" number="6.2.5.1" targetptr="TDPSG44334"> <ttl>Checking Whether a Wallet Is Open or Closed</ttl> <xreftext>“Checking Whether a Wallet Is Open or Closed”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data015.htm" number="6.2.5.2" targetptr="TDPSG44331"> <ttl>Checking Encrypted Columns of an Individual Table</ttl> <xreftext>“Checking Encrypted Columns of an Individual Table”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data016.htm" number="6.2.5.3" targetptr="TDPSG44332"> <ttl>Checking All Encrypted Table Columns in the Current Database Instance</ttl> <xreftext>“Checking All Encrypted Table Columns in the Current Database Instance”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data017.htm" number="6.2.5.4" targetptr="TDPSG44333"> <ttl>Checking Encrypted Tablespaces in the Current Database Instance</ttl> <xreftext>“Checking Encrypted Tablespaces in the Current Database Instance”</xreftext> <obj element="table" href="tdpsg_securing_data017.htm" number="6-1" targetptr="TDPSG94373"> <ttl>Data Dictionary Views for Encrypted Tablespaces</ttl> <xreftext>“Data Dictionary Views for Encrypted Tablespaces”</xreftext> </obj> </div> </div> </div> <div element="sect1" href="tdpsg_securing_data018.htm" number="6.3" targetptr="TDPSG90066"> <ttl>Choosing Between Oracle Virtual Private Database and Oracle Label Security</ttl> <xreftext>“Choosing Between Oracle Virtual Private Database and Oracle Label Security”</xreftext> <obj element="table" href="tdpsg_securing_data018.htm" number="6-2" targetptr=""> <ttl>Comparing Oracle Virtual Private Database with Oracle Label Security</ttl> <xreftext>“Comparing Oracle Virtual Private Database with Oracle Label Security”</xreftext> </obj> </div> <div element="sect1" href="tdpsg_securing_data019.htm" number="6.4" targetptr="TDPSG90034"> <ttl>Controlling Data Access with Oracle Virtual Private Database</ttl> <xreftext>“Controlling Data Access with Oracle Virtual Private Database”</xreftext> <div element="sect2" href="tdpsg_securing_data020.htm" number="6.4.1" targetptr="TDPSG30341"> <ttl>About Oracle Virtual Private Database</ttl> <xreftext>“About Oracle Virtual Private Database”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data021.htm" number="6.4.2" targetptr="TDPSG30343"> <ttl>Tutorial: Creating an Oracle Virtual Private Database Policy</ttl> <xreftext>“Tutorial: Creating an Oracle Virtual Private Database Policy”</xreftext> <div element="sect3" href="tdpsg_securing_data022.htm" number="6.4.2.1" targetptr="TDPSG33431"> <ttl>Step 1: If Necessary, Create the Security Administrator Account</ttl> <xreftext>“Step 1: If Necessary, Create the Security Administrator Account”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data023.htm" number="6.4.2.2" targetptr="TDPSG33437"> <ttl>Step 2: Update the Security Administrator Account</ttl> <xreftext>“Step 2: Update the Security Administrator Account”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data024.htm" number="6.4.2.3" targetptr="TDPSG33432"> <ttl>Step 3: Create User Accounts for This Tutorial</ttl> <xreftext>“Step 3: Create User Accounts for This Tutorial”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data025.htm" number="6.4.2.4" targetptr="TDPSG33433"> <ttl>Step 4: Create the F_POLICY_ORDERS Policy Function</ttl> <xreftext>“Step 4: Create the F_POLICY_ORDERS Policy Function”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data026.htm" number="6.4.2.5" targetptr="TDPSG33434"> <ttl>Step 5: Create the ACCESSCONTROL_ORDERS Virtual Private Database Policy</ttl> <xreftext>“Step 5: Create the ACCESSCONTROL_ORDERS Virtual Private Database Policy”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data027.htm" number="6.4.2.6" targetptr="TDPSG33435"> <ttl>Step 6: Test the ACCESSCONTROL_ORDERS Virtual Private Database Policy</ttl> <xreftext>“Step 6: Test the ACCESSCONTROL_ORDERS Virtual Private Database Policy”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data028.htm" number="6.4.2.7" targetptr="TDPSG33436"> <ttl>Step 7: Optionally, Remove the Components for This Tutorial</ttl> <xreftext>“Step 7: Optionally, Remove the Components for This Tutorial”</xreftext> </div> </div> </div> <div element="sect1" href="tdpsg_securing_data029.htm" number="6.5" targetptr="TDPSG30035"> <ttl>Enforcing Row-Level Security with Oracle Label Security</ttl> <xreftext>“Enforcing Row-Level Security with Oracle Label Security”</xreftext> <div element="sect2" href="tdpsg_securing_data030.htm" number="6.5.1" targetptr="TDPSG30351"> <ttl>About Oracle Label Security</ttl> <xreftext>“About Oracle Label Security”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data031.htm" number="6.5.2" targetptr="TDPSG30352"> <ttl>Guidelines for Planning an Oracle Label Security Policy</ttl> <xreftext>“Guidelines for Planning an Oracle Label Security Policy”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data032.htm" number="6.5.3" targetptr="TDPSG30354"> <ttl>Tutorial: Applying Security Labels to the HR.LOCATIONS Table</ttl> <xreftext>“Tutorial: Applying Security Labels to the HR.LOCATIONS Table”</xreftext> <div element="sect3" href="tdpsg_securing_data033.htm" number="6.5.3.1" targetptr="TDPSG33541"> <ttl>Step 1: Register Oracle Label Security and Enable the LBACSYS Account</ttl> <xreftext>“Step 1: Register Oracle Label Security and Enable the LBACSYS Account”</xreftext> <obj element="bridgehead" href="tdpsg_securing_data033.htm" number="" targetptr="TDPSG94384"> <ttl>Registering Oracle Label Security with Oracle Database</ttl> <xreftext>“Registering Oracle Label Security with Oracle Database”</xreftext> </obj> <obj element="bridgehead" href="tdpsg_securing_data033.htm" number="" targetptr="TDPSG94386"> <ttl>Enabling the Default Oracle Label Security User Account LBACSYS</ttl> <xreftext>“Enabling the Default Oracle Label Security User Account LBACSYS”</xreftext> </obj> </div> <div element="sect3" href="tdpsg_securing_data034.htm" number="6.5.3.2" targetptr="TDPSG33542"> <ttl>Step 2: Create a Role and Three Users for the Oracle Label Security Tutorial</ttl> <xreftext>“Step 2: Create a Role and Three Users for the Oracle Label Security Tutorial”</xreftext> <obj element="bridgehead" href="tdpsg_securing_data034.htm" number="" targetptr="TDPSG94388"> <ttl>Creating a Role</ttl> <xreftext>“Creating a Role”</xreftext> </obj> <obj element="bridgehead" href="tdpsg_securing_data034.htm" number="" targetptr="TDPSG94390"> <ttl>Creating the Users</ttl> <xreftext>“Creating the Users”</xreftext> </obj> </div> <div element="sect3" href="tdpsg_securing_data035.htm" number="6.5.3.3" targetptr="TDPSG33543"> <ttl>Step 3: Create the ACCESS_LOCATIONS Oracle Label Security Policy</ttl> <xreftext>“Step 3: Create the ACCESS_LOCATIONS Oracle Label Security Policy”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data036.htm" number="6.5.3.4" targetptr="TDPSG3354"> <ttl>Step 4: Define the ACCESS_LOCATIONS Policy-Level Components</ttl> <xreftext>“Step 4: Define the ACCESS_LOCATIONS Policy-Level Components”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data037.htm" number="6.5.3.5" targetptr="TDPSG33545"> <ttl>Step 5: Create the ACCESS_LOCATIONS Policy Data Labels</ttl> <xreftext>“Step 5: Create the ACCESS_LOCATIONS Policy Data Labels”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data038.htm" number="6.5.3.6" targetptr="TDPSG33546"> <ttl>Step 6: Create the ACCESS_LOCATIONS Policy User Authorizations</ttl> <xreftext>“Step 6: Create the ACCESS_LOCATIONS Policy User Authorizations”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data039.htm" number="6.5.3.7" targetptr="TDPSG33547"> <ttl>Step 7: Apply the ACCESS_LOCATIONS Policy to the HR.LOCATIONS Table</ttl> <xreftext>“Step 7: Apply the ACCESS_LOCATIONS Policy to the HR.LOCATIONS Table”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data040.htm" number="6.5.3.8" targetptr="TDPSG33548"> <ttl>Step 8: Add the ACCESS_LOCATIONS Labels to the HR.LOCATIONS Data</ttl> <xreftext>“Step 8: Add the ACCESS_LOCATIONS Labels to the HR.LOCATIONS Data”</xreftext> <obj element="bridgehead" href="tdpsg_securing_data040.htm" number="" targetptr="TDPSG94397"> <ttl>Granting HR FULL Policy Privilege for the HR.LOCATIONS Table</ttl> <xreftext>“Granting HR FULL Policy Privilege for the HR.LOCATIONS Table”</xreftext> </obj> <obj element="bridgehead" href="tdpsg_securing_data040.htm" number="" targetptr="TDPSG94399"> <ttl>Updating the OLS_COLUMN Table in HR.LOCATIONS</ttl> <xreftext>“Updating the OLS_COLUMN Table in HR.LOCATIONS”</xreftext> </obj> </div> <div element="sect3" href="tdpsg_securing_data041.htm" number="6.5.3.9" targetptr="TDPSG33549"> <ttl>Step 9: Test the ACCESS_LOCATIONS Policy</ttl> <xreftext>“Step 9: Test the ACCESS_LOCATIONS Policy”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data042.htm" number="6.5.3.10" targetptr="TDPSG93549"> <ttl>Step 10: Optionally, Remove the Components for This Tutorial</ttl> <xreftext>“Step 10: Optionally, Remove the Components for This Tutorial”</xreftext> </div> </div> </div> <div element="sect1" href="tdpsg_securing_data043.htm" number="6.6" targetptr="TDPSG90065"> <ttl>Controlling Administrator Access with Oracle Database Vault</ttl> <xreftext>“Controlling Administrator Access with Oracle Database Vault”</xreftext> <div element="sect2" href="tdpsg_securing_data044.htm" number="6.6.1" targetptr="TDPSG90651"> <ttl>About Oracle Database Vault</ttl> <xreftext>“About Oracle Database Vault”</xreftext> </div> <div element="sect2" href="tdpsg_securing_data045.htm" number="6.6.2" targetptr="TDPSG90652"> <ttl>Tutorial: Controlling Administrator Access to the OE Schema</ttl> <xreftext>“Tutorial: Controlling Administrator Access to the OE Schema”</xreftext> <div element="sect3" href="tdpsg_securing_data046.htm" number="6.6.2.1" targetptr="TDPSG66521"> <ttl>Step 1: Enable Oracle Database Vault</ttl> <xreftext>“Step 1: Enable Oracle Database Vault”</xreftext> <obj element="bridgehead" href="tdpsg_securing_data046.htm" number="" targetptr="BGBJIGEE"> <ttl>Installing Oracle Database Vault</ttl> <xreftext>“Installing Oracle Database Vault”</xreftext> </obj> <obj element="bridgehead" href="tdpsg_securing_data046.htm" number="" targetptr="TDPSG94405"> <ttl>Registering Oracle Database Vault with Oracle Database</ttl> <xreftext>“Registering Oracle Database Vault with Oracle Database”</xreftext> </obj> <obj element="bridgehead" href="tdpsg_securing_data046.htm" number="" targetptr="TDPSG94407"> <ttl>Enabling Database Access Control for the Database Vault Account Manager Account</ttl> <xreftext>“Enabling Database Access Control for the Database Vault Account Manager Account”</xreftext> </obj> </div> <div element="sect3" href="tdpsg_securing_data047.htm" number="6.6.2.2" targetptr="TDPSG66522"> <ttl>Step 2: Grant the SELECT Privilege on the OE.CUSTOMERS Table to User SCOTT</ttl> <xreftext>“Step 2: Grant the SELECT Privilege on the OE.CUSTOMERS Table to User SCOTT”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data048.htm" number="6.6.2.3" targetptr="TDPSG66523"> <ttl>Step 3: Select from the OE.CUSTOMERS Table as Users SYS and SCOTT</ttl> <xreftext>“Step 3: Select from the OE.CUSTOMERS Table as Users SYS and SCOTT”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data049.htm" number="6.6.2.4" targetptr="TDPSG66524"> <ttl>Step 4: Create a Realm to Protect the OE.CUSTOMERS Table</ttl> <xreftext>“Step 4: Create a Realm to Protect the OE.CUSTOMERS Table”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data050.htm" number="6.6.2.5" targetptr="TDPSG66525"> <ttl>Step 5: Test the OE Protections Realm</ttl> <xreftext>“Step 5: Test the OE Protections Realm”</xreftext> </div> <div element="sect3" href="tdpsg_securing_data051.htm" number="6.6.2.6" targetptr="TDPSG66526"> <ttl>Step 6: Optionally, Remove the Components for This Tutorial</ttl> <xreftext>“Step 6: Optionally, Remove the Components for This Tutorial”</xreftext> </div> </div> </div> </div> <div element="chapter" href="tdpsg_auditing.htm" number="7" targetptr="TDPSG50000"> <ttl>Auditing Database Activity</ttl> <xreftext>“Auditing Database Activity”</xreftext> <div element="sect1" href="tdpsg_auditing001.htm" number="7.1" targetptr="TDPSG50051"> <ttl>About Auditing</ttl> <xreftext>“About Auditing”</xreftext> </div> <div element="sect1" href="tdpsg_auditing002.htm" number="7.2" targetptr="TDPSG50511"> <ttl>Why Is Auditing Used?</ttl> <xreftext>“Why Is Auditing Used?”</xreftext> </div> <div element="sect1" href="tdpsg_auditing003.htm" number="7.3" targetptr="TDPSG50513"> <ttl>Where Are Standard Audited Activities Recorded?</ttl> <xreftext>“Where Are Standard Audited Activities Recorded?”</xreftext> </div> <div element="sect1" href="tdpsg_auditing004.htm" number="7.4" targetptr="TDPSG50052"> <ttl>Auditing General Activities Using Standard Auditing</ttl> <xreftext>“Auditing General Activities Using Standard Auditing”</xreftext> <div element="sect2" href="tdpsg_auditing005.htm" number="7.4.1" targetptr="TDPSG52529"> <ttl>About Standard Auditing</ttl> <xreftext>“About Standard Auditing”</xreftext> </div> <div element="sect2" href="tdpsg_auditing006.htm" number="7.4.2" targetptr="TDPSG50521"> <ttl>Enabling or Disabling the Standard Audit Trail</ttl> <xreftext>“Enabling or Disabling the Standard Audit Trail”</xreftext> </div> <div element="sect2" href="tdpsg_auditing007.htm" number="7.4.3" targetptr="TDPSG50522"> <ttl>Using Default Auditing for Security-Relevant SQL Statements and Privileges</ttl> <xreftext>“Using Default Auditing for Security-Relevant SQL Statements and Privileges”</xreftext> <div element="sect3" href="tdpsg_auditing008.htm" number="7.4.3.1" targetptr="TDPSG55221"> <ttl>About Default Auditing</ttl> <xreftext>“About Default Auditing”</xreftext> </div> <div element="sect3" href="tdpsg_auditing009.htm" number="7.4.3.2" targetptr="TDPSG55222"> <ttl>Enabling Default Auditing</ttl> <xreftext>“Enabling Default Auditing”</xreftext> </div> </div> <div element="sect2" href="tdpsg_auditing010.htm" number="7.4.4" targetptr="TDPSG50523"> <ttl>Individually Auditing SQL Statements</ttl> <xreftext>“Individually Auditing SQL Statements”</xreftext> </div> <div element="sect2" href="tdpsg_auditing011.htm" number="7.4.5" targetptr="TDPSG50524"> <ttl>Individually Auditing Privileges</ttl> <xreftext>“Individually Auditing Privileges”</xreftext> </div> <div element="sect2" href="tdpsg_auditing012.htm" number="7.4.6" targetptr="TDPSG50525"> <ttl>Using Proxies to Audit SQL Statements and Privileges in a Multitier Environment</ttl> <xreftext>“Using Proxies to Audit SQL Statements and Privileges in a Multitier Environment”</xreftext> </div> <div element="sect2" href="tdpsg_auditing013.htm" number="7.4.7" targetptr="TDPSG50526"> <ttl>Individually Auditing Schema Objects</ttl> <xreftext>“Individually Auditing Schema Objects”</xreftext> </div> <div element="sect2" href="tdpsg_auditing014.htm" number="7.4.8" targetptr="TDPSG50527"> <ttl>Auditing Network Activity</ttl> <xreftext>“Auditing Network Activity”</xreftext> </div> </div> <div element="sect1" href="tdpsg_auditing015.htm" number="7.5" targetptr="TDPSG50528"> <ttl>Tutorial: Creating a Standard Audit Trail</ttl> <xreftext>“Tutorial: Creating a Standard Audit Trail”</xreftext> <div element="sect2" href="tdpsg_auditing016.htm" number="7.5.1" targetptr="TDPSG55281"> <ttl>Step 1: Log In and Enable Standard Auditing</ttl> <xreftext>“Step 1: Log In and Enable Standard Auditing”</xreftext> </div> <div element="sect2" href="tdpsg_auditing017.htm" number="7.5.2" targetptr="TDPSG55282"> <ttl>Step 2: Enable Auditing for SELECT Statements on the OE.CUSTOMERS Table</ttl> <xreftext>“Step 2: Enable Auditing for SELECT Statements on the OE.CUSTOMERS Table”</xreftext> </div> <div element="sect2" href="tdpsg_auditing018.htm" number="7.5.3" targetptr="TDPSG55283"> <ttl>Step 3: Test the Audit Settings</ttl> <xreftext>“Step 3: Test the Audit Settings”</xreftext> </div> <div element="sect2" href="tdpsg_auditing019.htm" number="7.5.4" targetptr="TDPSG55284"> <ttl>Step 4: Optionally, Remove the Components for This Tutorial</ttl> <xreftext>“Step 4: Optionally, Remove the Components for This Tutorial”</xreftext> <obj element="bridgehead" href="tdpsg_auditing019.htm" number="" targetptr="TDPSG94423"> <ttl>To set AUDIT_TRAIL to its original value:</ttl> <xreftext>“To set AUDIT_TRAIL to its original value:”</xreftext> </obj> </div> <div element="sect2" href="tdpsg_auditing020.htm" number="7.5.5" targetptr="TDPSG55285"> <ttl>Step 5: Remove the SEC_ADMIN Security Administrator Account</ttl> <xreftext>“Step 5: Remove the SEC_ADMIN Security Administrator Account”</xreftext> </div> </div> <div element="sect1" href="tdpsg_auditing021.htm" number="7.6" targetptr="TDPSG60068"> <ttl>Guidelines for Auditing</ttl> <xreftext>“Guidelines for Auditing”</xreftext> <div element="sect2" href="tdpsg_auditing022.htm" number="7.6.1" targetptr="TDPSG60681"> <ttl>Guideline for Using Default Auditing of SQL Statements and Privileges</ttl> <xreftext>“Guideline for Using Default Auditing of SQL Statements and Privileges”</xreftext> </div> <div element="sect2" href="tdpsg_auditing023.htm" number="7.6.2" targetptr="TDPSG60682"> <ttl>Guidelines for Managing Audited Information</ttl> <xreftext>“Guidelines for Managing Audited Information”</xreftext> </div> <div element="sect2" href="tdpsg_auditing024.htm" number="7.6.3" targetptr="TDPSG60683"> <ttl>Guidelines for Auditing Typical Database Activity</ttl> <xreftext>“Guidelines for Auditing Typical Database Activity”</xreftext> </div> <div element="sect2" href="tdpsg_auditing025.htm" number="7.6.4" targetptr="TDPSG60684"> <ttl>Guidelines for Auditing Suspicious Database Activity</ttl> <xreftext>“Guidelines for Auditing Suspicious Database Activity”</xreftext> </div> </div> <div element="sect1" href="tdpsg_auditing026.htm" number="7.7" targetptr="TDPSG50514"> <ttl>Initialization Parameters Used for Auditing</ttl> <xreftext>“Initialization Parameters Used for Auditing”</xreftext> <obj element="table" href="tdpsg_auditing026.htm" number="7-1" targetptr="TDPSG94425"> <ttl>Initialization Parameters Used for Auditing</ttl> <xreftext>“Initialization Parameters Used for Auditing”</xreftext> </obj> </div> </div> </div>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de