Sybase DC35823-01-1500-04 manual 116, Creating a device for an audit table

Models: DC35823-01-1500-04

1 150
Download 150 pages 34.25 Kb
Page 132
Image 132

Adding auditing

1.Release directory: /usr/u/sybase

2.Configure a Server product

3Select Configure a Server Product.

4Select Adaptive Server.

5Select Configure an Existing Sybase Server.

6Select the server to configure.

7Provide the SA password for the server you selected.

8From the Sybase Server Configuration screen, select Configure Auditing.

As you proceed through the menus in auditinit, you can change any default values that appear. As you finish each menu, press Ctrl+A to accept the defaults or changed values and move to the next menu.

CONFIGURE AUDITING

1.Configure auditing: no

2.Add a device for audit table(s)

3.Add a device for the audit database transaction log

4.Delete a device entry

5.Change a device entry

List of devices

for the audit tables:

 

 

 

Logical name

Physical

name

Segment name

Table

name

Size

Device for the audit datbase transaction log:

 

 

 

Logical name

Physical

name

Segment name

Table

name

Size

9From the Configure Auditing screen, select Configure Auditing.

auditinit redisplays the Configure Auditing menu with the value “yes” displayed for Configure Auditing.

10Restart Adaptive Server for the changes to take effect.

vCreating a device for an audit table

1From the Configure Auditing screen, select Add a Device for Audit Table(s).

auditinit displays the following menu:

ADD/CHANGE A NEW DEVICE FOR AUDITING

1.sybsecurity physical device name:

2.Logical name of the device:

3.Size of the device (Meg):

4.Device size for auditing:

116

Adaptive Server Enterprise

Page 132
Image 132
Sybase DC35823-01-1500-04 manual 116, Creating a device for an audit table