These steps include dropping the sybsecurity database,
which destroys all audit records and global audit settings previously
recorded in sybsecurity. Before you drop the sybsecurity database,
make sure you archive existing records with a backup or by following
instructions in “Archiving the audit table” to avoid losing any historical
data that remains in the sybsecurity tables.
To move the sybsecurity database without saving the global audit settings:
Execute the following to remove any information related to logins from the syslogins system table:
sp_audit "all","all","all","off"
Drop the sybsecurity database.
Install sybsecurity again using the installation procedure described in either:
The configuration documentation for your platform, or
During the installation process, place the sybsecurity database on one or more devices, separate from the master device.
