Re: Intercepting internal error

James T Ford wrote: > > I don't believe this is possible but I figured I'd ask anyways. > > The problem: > > Our users connect from PC's via various tools. We have security > levels implemented on some of our tables. I would like to be able to > run a daemon that will trap whenever a user tries to access data that > they are not allowed to (sqlerr 272). > Have you tried auditing ? Auditing can give you detailed information regarding what each user has been trying to do. However, you may not be able to trap the user though. But I guess you could warn them later, since they can't get to the data anyways! Now, it could get a bit tricky if many of your PC clients are using the same user-id to get to the server. You then need to look at sid, connect time, and probably more to isolate a single user for accountability. I am still working on such a situation because of the access thru firewall and can't give more info! Good luck Arun PS : A Smith & Wesson might come in handy!