Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 17:48:37 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Restricting IPs
From:   Anomy Anom

<-- Anonymously Posted: Friday, January 07, 2005 12:13 -->

I would like to take Christopher's suggestion on step further. If Teradata can identify the IP address, can a trigger be written against the logon/logoff database to run a macro/stored procedure to check the IP address and either logoff the session or change the permissions to the session when that session logs on?. Then even users with raw utilities (BTEQ, SQLA, etc) will be restricted. I would think a decent DBA would be able to write something like this.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023