Created On:  06 December 2011

Problem:

Is it possible to delete the contents of the StarTeam security log?

Resolution:

Unlike the Audit Log, StarTeam does not have a server console option to delete/purge the security log. So purging the contents of the Security Log can only be done at the database level. There are two options are available:

1. Open SQL or Oracle enterprise manager console and run the command

execute purge_seclog XX

The XX denotes the number of days to purge data from the table.

2. Open SQL or Oracle enterprise manager console and run the command

TRUNCATE TABLE " syn_ObjectSecLog”

This operation is almost instant and much faster than option 1 above.

Please take a database backup before attempting any of the operations above.