Running the installsecurity Script

If you use the Sybase auditing feature, rerun the installsecurity script. This script reinstalls the following stored procedures:

sp_addauditrecord
sp_audit
sp_aux_getsptaud
sp_aux_displaylogaud
sp_aux_displayoptaud
sp_aux_displaysprocaud
sp_aux_displaydbaud
sp_displayaudit
sp_addaudittable

Note:

If you modified any of these Sybase system stored procedures without changing the names, executing installsecurity overwrites your modifications. In this case, you must reload the modified stored procedures after you run the installsecurity script.

Using isql, run the new installsecurity script included with this release.

isql -Usa -P<sa password> -S<servername> -n
     -i$SYBASE/$SYBASE_ASE/scripts/installsecurity 
     -o<output file>

Where:

-P is the password parameter
-S is servername parameter

Save the output of this step to an operating system file.