Sybase Adaptive Server 15.0.2, Руководство по установке

Страница: 91 / 160

CHAPTER 5 Upgrading Adaptive Server
Installation Guide
77
Reenabling auditing
Reenable all auditing options for stored procedures using the audit options you
recorded during pre-upgrade. Reenter the audit options using
sp_audit
.
For example, if you had enabled stored procedure auditing for
sp_addlogin
stored procedure in your server before upgrade, run the following
sp_audit
command to reenable auditing on
sp_addlogin
:
sp_audit "exec_procedure", "all", "sp_addlogin", "on"
Adaptive Server 12.5.x and later includes the following global audit options for
sp_audit
:
•
security
•
dbcc
The functionality provided by the following
sp_auditoption
options is now
covered by the
sp_audit security
global audit option:
•
server boot
•
roles
These options are turned off by default and are not turned on even if you used
sp_auditoption "all", "on"
to turn on all global audit options in a version earlier
than 11.5.
To turn on these options, use:
1> sp_audit "security", "all", "all", "on"
2> go
1> sp_audit "dbcc", "all", "all", "on"
2> go
For more information, see the Reference Manual.
Special considerations for threshold procedures for audit segments
If your installation used a threshold procedure to archive the
sysaudits
table
using T-SQL similar to the following example:
INSERT MyPre15SysAuditHistoryTable SELECT * FROM
sysaudits_0n
Where n corresponds to the
sysaudits
table number 1 – 8 and
MyPre15SysAuditHistoryTable is a table defined prior to Adaptive Server
version 15.0.2, then you must alter MyPre15SysAuditHistoryTable to add a
nodeid
column using the following command: