What is the use of sp_displayaudit "database"

[william-paul_philibert]

Bonjour,

I'm working with Sypase ASE Auditing and I have a questiopn regarding sp_displayaudit "database" command.

I have a db "mydatabase" where I set up auditing on table "mytable" for select, insert, delete and update.

When I query :

sp_displayaudit "database"

No databases currently have auditing enabled.

sp_displayaudit "database", "mydatabase"

No databases currently have auditing enabled.

What should be expected or what is the use for sp_dislpayaudit "database"

Doc is not very clear on this :

database

displays the status of audit options for the specified database. If you do not specify a value for <name>, the active audit options for all databases on the server are displayed.

Thanks for your time and support.

[william-paul_philibert · Accepted solution]

I just found the answer ...

database :

alter, bcp, bind, create, dbaccess, drop, dump, encryption_key, func_dbaccess, grant, load, revoke, setuser, truncate, unbind