Tracking security violations

Database

Tracking security violations

Hi, I will have to track the list of people who is violating security policies of my company. In order to do that from Teradata perspective, please help me with below info.

1. Table that has mapping between ip address of client machine and corresponding user name
2. Table that tracks list of ip addresses of machines where a user logged in in past 10 days.

Thanks
1 REPLY

Re: Tracking security violations

The dbqlogtbl lists the ip address etc and depending upon the retention policy of your DA group, should list them for at least ten days....