Red Hat NETSCAPE ENTREPRISE SERVER 6.1 - INSTALLATION AND MIGRATION GUIDE Guía de instalación descargar pdf (Pagina 85)

10.7.2 Reenabling Auditing

If the server you upgraded from was configured for auditing, reenable auditing in the upgraded server.

Procedure

1. Enter:

sp_configure 'auditing', 1

2. Reenable auditing for all system stored procedures for which auditing was enabled before the upgrade.

a) Use the output of sp_displayaudit recorded during the preupgrade process to identify the system

stored procedures for which auditing was enabled.

b) Reenter the audit options using sp_audit. For example, if you had enabled stored procedure auditing for

sp_addgroup stored procedure in your server before upgrading, run:

sp_audit "exec_procedure", "all", "sp_addgroup", "on"

10.7.2.1 Updating Threshold Procedures for Audit Segments

An post-upgrade task is required for threshold procedures used to archive audit segments.

If your previous installation used a threshold procedure, similar to this, execute the following to archive the

<sysaudits> table:

INSERT MyPre15SysAuditHistoryTable SELECT * FROM

sysaudits_0n

where <n> corresponds to the sysaudits table number 1–8 and MyPre15SysAuditHistoryTable is a table

defined prior to version 16.0, then you must alter MyPre15SysAuditHistoryTable to add a nodeid column

using:

alter table MyPre15SysAuditHistoryTable

add nodeid tinyint NULL

See the Reference Manual: Tables for system tables for details about the sysaudits tables.

Installation Guide for Linux

SAP ASE Upgrades

1 2 ... 80 81 82 83 84 85 86 87 88 89 90 ... 113 114

Sin comentarios

Red Hat NETSCAPE ENTREPRISE SERVER 6.1 - INSTALLATION AND MIGRATION GUIDE Guía de instalación Pagina 85