Configure a companion for auditing the same way you configure a server that does not use failover. For more information, see “Setting auditing options”.
All updates to user and security information (for example, sp_addlogin, sp_addrole, and so on) are performed on both the systems in transactional fashion. This keeps the user and security data identical on both companions.
For the following auditing parameters, both companions must be configured identically. These parameters are checked as a quorum attribute, or when explicitly listed with do_advisory:
allow procedure grouping
unified login required
secure default login
systemwide password expiration
use security services
check password for digit
minimum password length
maximum failed logins
auditing – turning this parameter on and off is not synchronized dynamically for the companions. If you change this parameter locally, you must manually update the remote companion.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
