Monitoring/Log access to a Database

Hi,
what possibilities there are to monitors access to a database. It is to be recorded, which user or client accesses it. And not on all tables, only tables to a certain scheme.
Background: The database will soon be switched off...
Thanks and
Regards
Nicole :wink:

you can use SQL Trace to log any activity on that database