You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for AUDIT_TRAIL


1 to 60 of 70 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Database Reference, 11g Release 1 (11.1)

AUDIT_TRAIL

AUDIT_TRAILProperty Description Parameter type String Syntax AUDIT_TRAIL = { none | os | db [, extended] | xml … [, extended] } Default value none Modifiable No Basic No AUDIT_TRAIL enables or disables database

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Table 9-2 AUDIT_TRAIL Parameter SettingsAUDIT_TRAIL Value Description DB Directs audit records to the standard audit records to the … was started in read-only mode with AUDIT_TRAIL set to DB, then Oracle Database internally sets … AUDIT_TRAIL to OS. Check the alert log for details. See also \"Managing the Database Audit Trail\". DB … , EXTENDED Behaves the same as AUDIT_TRAIL=DB,

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Configuring Standard Auditing with the AUDIT_TRAIL Initialization ParameterThis section contains: Enabling or Disabling the Standard Audit Trail Settings for the AUDIT_TRAIL … audit trail by setting the AUDIT_TRAIL initialization parameter. This setting determines whether to … database instance. To check the current value of the AUDIT_TRAIL parameter, use the SHOW PARAMETER … command in SQL*Plus. Example

Label Security Administrator's Guide, 11g Release 1 (11.1)

Auditing Under Oracle Label Security

12.2 Enabling Systemwide Auditing: AUDIT_TRAIL Initialization Parametersetting the Oracle Database AUDIT_TRAIL initialization parameter in the database's parameter file … . The parameter can be set to one of the following values: Table 12-1 AUDIT_TRAIL Parameter Settings

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Mining Model Schema Objects

Enabling Auditing in the DatabaseThe database initialization parameter AUDIT_TRAIL controls auditing capabilities in the database … . To enable auditing, set AUDIT_TRAIL to DB, DB_EXTENDED, or OS. Set AUDIT_TRAIL to NONE to prevent … auditing information from being recorded. By default, AUDIT_TRAIL is set to NONE.

Database Security Guide, 11g Release 1 (11.1)

Keeping Your Oracle Database Secure

Auditing Sensitive Informationif you collect SQL text. For standard auditing, setting the AUDIT_TRAIL initialization parameter to … would set the audit_trail parameter of the DBMS_FGA PL/SQL package to DBMS_FGA.DB + DBMS_FGA.EXTENDED or … : Set the AUDIT_TRAIL initialization parameter to DB, OS, or XML. See \"Configuring Standard Auditing … with the AUDIT_TRAIL

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

Sample Initialization Parameter File' audit_trail ='db' db_block_size=8192 db_domain='' db_recovery_file_dest='/flash_recovery_area

Database Reference, 11g Release 1 (11.1)

AUDIT_SYS_OPERATIONS

AUDIT_SYS_OPERATIONSoperating system's audit trail. The audit records will be written in XML format if the AUDIT_TRAIL … been set, then it overrides the AUDIT_TRAIL parameter and SYS audit records are written to the system audit log using the SYSLOG utility.

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Creating an Audit Trail for Fine-Grained Audit RecordsYou designate the audit trail format for fine-grained auditing by setting the audit_trail parameter … for the DBMS_FGA.ADD_POLICY policy (not to be confused with the AUDIT_TRAIL initialization … to the SYS.FGA_LOG$ table, then set the audit_trail parameter for the DBMS_FGA.ADD_POLICY parameter … DBMS_FGA.ADD_POLICY audit_trail

Database Reference, 11g Release 1 (11.1)

AUDIT_FILE_DEST

AUDIT_FILE_DESTthe audit trail is written when the AUDIT_TRAIL initialization parameter is set to os, xml, or xml … ,extended. The audit records will be written in XML format if the AUDIT_TRAIL initialization parameter

Database SQL Language Reference, 11g Release 1 (11.1)

AUDIT

AUDITauditing results, you must enable auditing by setting the initialization parameter AUDIT_TRAIL to a … AUDIT_TRAIL parameter Syntax audit::= Description of the illustration audit.gif

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Auditing User SYS and Users Who Connect as SYSDBA and SYSOPERoperating system file, even if the AUDIT_TRAIL parameter is set to NONE, DB, or DB, EXTENDED. Writing … AUDIT_TRAIL initialization parameter to either XML or XML, EXTENDED. For example: ALTER SYSTEM SET … AUDIT_TRAIL=XML, EXTENDED SCOPE=SPFILE; In all operating systems, if you set AUDIT_TRAIL to either XML or XML

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Auditing General Activities with Standard AuditingThis section contains: About Standard Auditing Configuring Standard Auditing with the AUDIT_TRAIL

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_FGA

ADD_POLICY Procedure, audit_trail BINARY_INTEGER IN DEFAULT, audit_column_opts BINARY_INTEGER IN DEFAULT); Parameters … audit_trail Destination (DB or XML) of fine grained audit records. Also specifies whether to populate LSQLTEXT … executed with the function owner's privilege. The audit_trail parameter specifies both where the fine … variable information

Database Error Messages, 11g Release 1 (11.1)

ORA-12700 to ORA-19400

ORA-16006: audit_trail destination incompatible with database open modeinstance. Action: Perform the necessary recovery and re-open for read-only access. ORA-16006: audit_trail destination incompatible with database open mode

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Activities That Are Always Written to the Standard and Fine-Grained Audit RecordsWhen standard auditing is enabled (that is, you set AUDIT_TRAIL to DB or DB,EXTENDED ), Oracle

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Using Default Auditing for Security-Relevant SQL Statements and Privilegessets the AUDIT_TRAIL initialization parameter to DB. If you decide to use a different auditing … disable auditing by setting the AUDIT_TRAIL parameter to NONE, then no auditing takes place. Oracle

Database Security Guide, 11g Release 1 (11.1)

Keeping Your Oracle Database Secure

Approaches to Addressing the CONNECT Role Changethat before auditing, the database initialization parameter AUDIT_TRAIL must be initialized and the … AUDIT_TRAIL initialized, for example, AUDIT_TRAIL=DB. Oracle Database auditing should then be turned on to

Database Reference, 11g Release 1 (11.1)

DBA_AUDIT_EXISTS

DBA_AUDIT_EXISTSand SQL_TEXT columns are only populated if the AUDIT_TRAIL initialization parameter is set to db, extended. See Also: \"AUDIT_TRAIL\"

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Table 9-1 Selecting an Auditing TypeDatabase Audit Trail\". Set the AUDIT_TRAIL initialization parameter to enable auditing and to select … Standard Auditing with the AUDIT_TRAIL Initialization Parameter\". Use the AUDIT and NOAUDIT SQL … location based on the AUDIT_TRAIL initialization parameter. See also \"About Audit Records\". General … fine-grained auditing

Database Reference, 11g Release 1 (11.1)

AUDIT_SYSLOG_LEVEL

AUDIT_SYSLOG_LEVELand standard audit records are being sent to the operating system ( AUDIT_TRAIL = OS ), then standard

Database Reference, 11g Release 1 (11.1)

DBA_AUDIT_STATEMENT

DBA_AUDIT_STATEMENTSQL_TEXT columns are only populated if the AUDIT_TRAIL initialization parameter is set to db, extended. See Also: \"AUDIT_TRAIL\"

Database Reference, 11g Release 1 (11.1)

DBA_AUDIT_OBJECT

DBA_AUDIT_OBJECTcolumns are only populated if the AUDIT_TRAIL initialization parameter is set to db, extended. See Also: \"AUDIT_TRAIL\"

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Managing the Operating System Audit Trailaudit trail is written, when the AUDIT_TRAIL initialization parameter is set to OS, XML, or XML … system audit trail becomes full, then set the AUDIT_TRAIL parameter to use database audit trail (such as

Database Reference, 11g Release 1 (11.1)

ALL_AUDIT_POLICIES

ALL_AUDIT_POLICIES) AUDIT_TRAIL VARCHAR2(12)   Indicates the audit trail to which the audit records generated by this audit policy

Database Security Guide, 11g Release 1 (11.1)

List of Tables

List of TablesData 9-1 Selecting an Auditing Type 9-2 AUDIT_TRAIL Parameter Settings 9-3 What the Operating System

Database Reference, 11g Release 1 (11.1)

DBA_FGA_AUDIT_TRAIL

DBA_FGA_AUDIT_TRAILfuture use Note: The SQL_BIND and SQL_TEXT columns are populated only if the policy has been created with the AUDIT_TRAIL parameter set to db, extended.

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Activities That Are Always Audited for All Platforms(that is, setting the AUDIT_TRAIL parameter to DB ), Oracle Database still writes mandatory records to

Label Security Administrator's Guide, 11g Release 1 (11.1)

Auditing Under Oracle Label Security

Setting Explanationapproach is recommended by Oracle. Note that even with AUDIT_TRAIL set to DB, some records are always sent … CONNECT AS SYSOPER or SYSDBA. DB_EXTENDED Does all actions of AUDIT_TRAIL=DB and also populates the … auditing will go to the database, with labels. If you set AUDIT_TRAIL to OS, then the Oracle Label … AUDIT_TRAIL

Database Reference, 11g Release 1 (11.1)

Changing Parameter Values in a Parameter File

Parameters by Functional CategoryAUDIT_SYSLOG_LEVEL AUDIT_TRAIL COMMIT_LOGGING COMMIT_WAIT O7_DICTIONARY_ACCESSIBILITY OS_AUTHENT_PREFIX

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Using the Syslog Audit Trail on UNIX Systemssteps: Assign a value of OS to the AUDIT_TRAIL initialization parameter, as described in \"Enabling … or Disabling the Standard Audit Trail\". For example: ALTER SYSTEM SET AUDIT_TRAIL=OS SCOPE=SPFILE

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

About Fine-Grained Auditinggrained audit policy with the audit_trail parameter of the DBMS_FGA.ADD_POLICY PL/SQL procedure to DB … initialization parameters such as AUDIT_TRAIL, you use the DBMS_FGA PL/SQL package to add and remove

Database Reference, 11g Release 1 (11.1)

DBA_AUDIT_TRAIL

DBA_AUDIT_TRAILare only populated if the AUDIT_TRAIL initialization parameter is set to db, extended. See Also: \"AUDIT_TRAIL\"

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Using the Operating System Audit Trailspecifies this number. The following values can appear if you set the AUDIT_TRAIL parameter to XML … procedure_one(:num); end; ) appears if you have set the AUDIT_TRAIL parameter to XML, EXTENDED. It … AUDIT_TRAIL initialization parameter is set to XML (or XML, EXTENDED ), then Oracle Database writes … AUDIT_TRAIL

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Using the DBMS_FGA Package to Manage Fine-Grained Audit PoliciesVARCHAR2, handler_module VARCHAR2, enable BOOLEAN, statement_types VARCHAR2, audit_trail BINARY_INTEGER … default is SELECT. audit_trail: Specifies the destination ( DB or XML ) of fine-grained audit records … , statement_types => 'INSERT, UPDATE, SELECT, DELETE', audit_trail => DBMS_FGA.DB); END; / At this point, if

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

About Standard Auditingregardless of the AUDIT_TRAIL parameter setting. If auditing has been disabled, the next time it is

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Tutorial: Auditing Nondatabase Users', AUDIT_TRAIL => DBMS_FGA.DB + DBMS_FGA.EXTENDED, AUDIT_COLUMN_OPTS => DBMS_FGA.ANY_COLUMNS); END; / In this

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Managing the Database Audit Trail… For example, if you have set the AUDIT_TRAIL initialization parameter to DB, EXTENDED or XML … DBA_AUDIT_TRAIL view may change across Oracle Database releases. Note: If the AUDIT_TRAIL initialization

Label Security Administrator's Guide, 11g Release 1 (11.1)

Auditing Under Oracle Label Security

12 Auditing Under Oracle Label Security: Overview of Oracle Label Security Auditing Enabling Systemwide Auditing: AUDIT_TRAIL Initialization

Database Security Guide, 11g Release 1 (11.1)

List of Examples

List of ExamplesDBMS_RLS.ADD_POLICY 9-1 Checking the Current Value of the AUDIT_TRAIL Initialization Parameter 9-2 Enabling

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Tutorial: Adding an Email Alert to a Fine-Grained Audit Policy', audit_trail => DBMS_FGA.DB + DBMS_FGA.EXTENDED); END; / Commit the changes you have made to the database

Database Security Guide, 11g Release 1 (11.1)

Database Security Guide - Contents

ContentsAUDIT_TRAIL Initialization Parameter Enabling or Disabling the Standard Audit Trail Settings for … the AUDIT_TRAIL Initialization Parameter What Do the Operating System and Database Audit Trails Have

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Mining Model Schema Objects

Viewing the Audit TrailNOAUDIT statements Oracle Database Reference for documentation of the AUDIT_TRAIL initialization

Database Utilities, 11g Release 1 (11.1)

Using the Metadata API

19 Using the Metadata APIa dummy table, audit_trail. This table is used to show that tables that do not start with \"PAYROLL … \" are not retrieved by the GET_PAYROLL_TABLES procedure. SQL> CREATE TABLE audit_trail 2

Database Reference, 11g Release 1 (11.1)

Database Reference - Contents

ContentsASM_PREFERRED_READ_FAILURE_GROUPS AUDIT_FILE_DEST AUDIT_SYS_OPERATIONS AUDIT_SYSLOG_LEVEL AUDIT_TRAIL BACKGROUND_CORE_DUMP

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Auditing Oracle Database Vault

Format of the Oracle Database Vault Audit TrailThe Oracle Database Vault audit event records are stored in the AUDIT_TRAIL$ table, which is part … the AUDIT_TRAIL$ table. In fact, even if auditing has been disabled in Oracle Database, then the … Oracle Database Vault audit functionality continues to write to the AUDIT_TRAIL$ table. Users who have … trail, which you must understand

Label Security Administrator's Guide, 11g Release 1 (11.1)

List of Tables

List of TablesOption Combinations 10-1 Policy Administration Functions 12-1 AUDIT_TRAIL Parameter Settings 12-2

Database 2 Day + Security Guide, 11g Release 1 (11.1)

Auditing Database Activity

Initialization Parameter Default Setting DescriptionAUDIT_TRAIL DB Enables or disables auditing. See \"Enabling or Disabling the Standard Audit Trail … AUDIT_TRAIL initialization parameter is set to OS, XML, or XML,EXTENDED. Oracle Database writes the … audit records in XML format if the AUDIT_TRAIL initialization parameter is set to XML. Oracle Database … operating system. If

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Auditing Oracle Database Vault

Oracle Database Audit Settings Created for Oracle Database VaultAUDIT_TRAIL initialization parameter. By default, auditing is disabled in Oracle Database.

Database 2 Day + Security Guide, 11g Release 1 (11.1)

Auditing Database Activity

Step 4: Optionally, Remove the Components for This TutorialAUDIT_TRAIL to its original value: Follow the procedure in \"Step 1: Log In and Enable Standard … Auditing\" to log in to SQL*Plus and set the AUDIT_TRAIL parameter back to its original value. Afterward, shut down and then restart the database.

Label Security Administrator's Guide, 11g Release 1 (11.1)

Label Security Administrator's Guide - Contents

ContentsSystemwide Auditing: AUDIT_TRAIL Initialization Parameter 12.3 Enabling Oracle Label Security Auditing with

Database 2 Day + Security Guide, 11g Release 1 (11.1)

Auditing Database Activity

Step 1: Log In and Enable Standard Auditing… Go to the next step. In the Name field, enter AUDIT_TRAIL to find the AUDIT_TRAIL parameter, and then … . Alternatively, you can scroll down the list of parameters to find the AUDIT_TRAIL parameter. To sort the list of

Database Platform Guide for Microsoft Windows, 11g Release 1 (11.1)

Monitoring a Database on Windows

Managing Event ViewerSetting AUDIT_TRAIL to db or os causes more records to be written to Event Viewer. This can fill up

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Monitoring Oracle Database Vault

Security Violation AttemptsAUDIT_TRAIL initialization parameter is set to DB or DB, EXTENDED. For detailed information about the … AUDIT_TRAIL parameter settings, see Oracle Database Security Guide. To check for security violations: Log

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Monitoring Oracle Database Vault

Security Policy Changes Detailensure that the AUDIT_TRAIL initialization parameter is set to DB or DB, EXTENDED. For detailed … information about the AUDIT_TRAIL parameter settings, see Oracle Database Security Guide. To monitor

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Oracle Database Vault Reports

Security Audit Report: Core Database Audit Reportrecords that are captured if the database initialization parameter AUDIT_TRAIL has been set to DB … . For more information about the AUDIT_TRAIL parameter, see Oracle Database SQL Language Reference.

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Monitoring Oracle Database Vault

Database Configuration and Structural Changesyou can view these events, you must ensure that the AUDIT_TRAIL initialization parameter is set to DB … or DB, EXTENDED. For detailed information about the AUDIT_TRAIL parameter settings, see Oracle

Database 2 Day + Security Guide, 11g Release 1 (11.1)

Auditing Database Activity

Enabling or Disabling the Standard Audit Trailnext step. In the Name field, enter audit_trail to find the AUDIT_TRAIL parameter, and then click … can scroll down the list of parameters to find the AUDIT_TRAIL parameter. In the Value field, select … . Otherwise, the default is DB.) DB, EXTENDED: Performs all actions of the AUDIT_TRAIL=DB setting and also

Database Vault Administrator's Guide, 11g Release 1 (11.1)

Integrating Oracle Database Vault with Other Oracle Products

Tutorial: Integrating Oracle Database Vault with Oracle Label SecurityCheck the current setting for the AUDIT_TRAIL initialization parameter. SHOW PARAMETER AUDIT_TRAIL … NAME TYPE VALUE ------------------------------------ ----------- ---------------------- audit_trail … . As user mdale, use the ALTER SYSTEM statement to modify the AUDIT_TRAIL parameter. ALTER SYSTEM SET … AUDIT_TRAIL=OS,

Database 2 Day + Security Guide, 11g Release 1 (11.1)

Auditing Database Activity

ALTER ANY PROCEDURE CREATE ANY LIBRARY DROP ANY TABLEaudits some of the security-relevant SQL statements and privileges. It also sets the AUDIT_TRAIL … the AUDIT_TRAIL parameter to NONE, then no auditing takes place. Oracle Database audits the AUDIT ROLE … Reference for detailed information about the SQL statements described in this section and the AUDIT_TRAIL initialization parameter