What kind of auditing can be collected from Sybase ASE?
The Sybase ASE audit record can log the database event, the date and time, the user responsible for it, and the success or failure of the event. Among the events that can be audited are logins and logouts, server boots, use of data access commands, attempts to access particular objects, and a particular user’s actions. You can establish auditing for events such as: · Server-wide, security-relevant events · Creating, deleting, and modifying database objects · All actions by a particular user or all actions by users with a particular role active · Granting or revoking database access · Importing or exporting data · Logins and logouts The type of auditing option you specify include: · Global options apply to commands that affect the entire server, such as booting the server, disk commands, and allowing ad hoc, user-defined audit records. · Database-specific options apply to a database. Examples include altering a database, bulk copy of data into a database, granting or revoking access to
