Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Security Audit Logging 1

Status
Not open for further replies.

ps32208

Technical User
Jul 29, 2005
42
EU
Hi,

I need to record a security log which will tells me who logs onto my database, when and what they do in it. Is this possible, if so how?

Any help is greatly appreciated.

Regards,
Pete.
 
Where are you starting from? DO you have Access workgroup security in place?

 
Yes I have an Access workgroup in place.
 
So you can identify the user, then.
'when they log on' would seem to be just an autoexec job to write to a log file.
'What they do' is a different scale altogether. You have to identify which actions you want to log and you have to write code that traps each one of those actions and writes to the log file. Should keep you in work for a week or two:)-)






 
sorry I should have added; with user level security.
 
ok thanks. If you have any tips on running an autoexec that would be great.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top