teradata_security_for_data_warehouse.htm

<html>
<head>
<title>Security of a Teradata Data Warehouse</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="styles/style.css">
</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<TABLE NAME="CHANGE MY WIDTH" WIDTH="100%" border=0 cellspacing=0 cellpadding=0><TR><TD>
<!-- CHANGING THE WIDTH ABOVE WILL CHANGE ALL PAGE WIDTH -->

<table NAME="HEADER" width="100%" border=0 cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr> 
<td height="100" valign="middle"><img src="images/dba_400_home.jpg" width="400" height="58" alt="Database Answers"></td>
<td ALIGN=right HEIGHT=95 ROWSPAN=2 width="100%" valign=middle>
<A HREF="http://www.amazon.com/Data-Governance-Example-Barry-Williams-ebook/dp/B00K53611E/ref=sr_1_14?ie=UTF8&qid=1422141473&sr=8-14&keywords=barry++williams" TARGET=_NEW>
<IMG ALT="Cover for my Book on Governance  by EXample (Click for the book on Amazon)" BORDER=0 SRC="images/grc_sml.jpg"> 
</td>
</td>
</td>
</tr>

<TR>
<td width="100%" align="LEFT">
<!---
<p class="time"><nobr><SCRIPT LANGUAGE="JavaScript">theDate();</SCRIPT> 

<IMG ALT="Printer" SRC="images/printer_icon.gif">
<A HREF="print_version.htm"><FONT COLOR=blue FACE=Verdana SIZE=1>Printer-friendly version</FONT></A>
<nobr></p>
--->
</td>
</TR>
</table>

<!--- START OF DEC 5th. Menu Bar --->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="32" background="images/nav_bg.jpg" align="left" valign="middle">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
	<td width="1%"><img src="images/spacer.gif" width="15" height="15"></td>
	<td width="6%"><A STYLE="text-decoration:none" HREF="index.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Home</font></A></td>
	<td width="11%"><A STYLE="text-decoration:none" HREF="pi_ask_a_question/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>
	Ask a Question</font></A></td>
	<td width="10%">
	<A STYLE="text-decoration:none" HREF="pi_best_practice_display/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>Best Practice</font></A></td>

    	<td width="9%">
<!--- <A STYLE="text-decoration:none" HREF="pi_communities/boards.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>Communities</font></A> --->
	<A STYLE="text-decoration:none" HREF="careers.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Careers</font></A>
	</td>
	<td width="9%"><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A>
	</td>
         <td width="10%"><A STYLE="text-decoration:none" HREF="data_models/index.htm"><font color=white FACE=Verdana SIZE=2>Data Models</font></A></td>
          <td width="7%"><A STYLE="text-decoration:none" HREF="search.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Search</font></td>
          <td WIDTH=20% WIiiiDTH=10% wiIIIdth="30%"><A STYLE="text-decoration:none" HREF="site_map.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Site Map</font></A></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<!--- END OF DEC 5th. Menu  Bar --->

<!--- START OF PAGE NAME --->
<FONT COLOR=blue FACE="Verdana" SIZE=2>
<TABLE bgcolor="#B0D8FF" BGCOLOuuuR="#98CEFD" BORDER=0 CELLPADDING=5 CELLSPACING=5 WIDTH=100%>
  <tr>
    <td height="32" background="images/nav_bg.jUg" align="left" valign=top>
      <table width="10%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
   	<td background="images/nav_bg.jpg" valign=top width="1%"><img src="images/spacer.gif" width="15" height="15"></td> 

	<td ALIGN=left background="images/nav_bg.jpg" height="32" width="10%"><PRE><FONT COLOR=yellow coloUUUr="#FFFFFF" FACE=Verdana SIZE=2>A Data Security Architecture for a Teradata Data Warehouse&nbsp;&nbsp;&nbsp;</font></td>
	</tr>
      </table>

    </td>
  </tr>
</TABLE>
<!--- END OF PAGE NAME --->

<table NAME="MAIN CONTENT" width="100%" border=0 cellspacing="0" cellpadding="0">
<tr> 
<td width="100%" bgcolor="#B0D8FF" valign="top"> 

<table width="90%" border=0 cellspacing="0" cellpadding="0">
<tr> 
<td width="21"><img src="images/spacer.gif" width="31" height="1"></td>
<td width="100%">
<FONT COLOR=blue FACE=Verdana SIZE=2>

I have written <B>a book on 'GRC by Example'</B> and you can click on the image in the top right-hand corner to find it on Amazon.
<BR><BR>

<TABLE BORDER=1 CELLPADDING=3 CELLSPACING=3>
<TR>
<TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<IMG ALIGN=middle ALT="Teradata Data Security Architecture" VALIGN=top SRC="images/teradata_data_security_architecture.jpg" usemap="#teradata_data_security_architecture" style="border-style:none"> 
</TD>

<TD ALIGN=left VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>

Requirements for a GRC Platform can be defined at the three levels in the diagram :-
<BR><BR><B>Governance</B> is concerned with Roles and Responsibilities which requires <A HREF="data_models/document_management_for_security/index.htm">Document Management</A>.
<BR><BR><B>Risk Management</B> requires some specific facilities and <A HREF="data_models/document_management_for_security/index.htm">Document Management</A> to run Scripts.

<BR><BR><B>Compliance</B> is concerned with Policies and Procedures.
<BR>This requires the same facilities to run Scripts and follow documented Procedures as Governance.

<BR><BR><A HREF="data_models/governance_risk_mgt_compliance_GRC/index.htm"><B>Click here</B></A> for the Data Model which is used to establish the features required in software support for the Risk Monitoring System.
<BR>Click on the diagram to go to the Teradata Web Site.

<BR><BR><BR><FONT COLOR=red>Scroll down to see the Risk Monitoring System.</FONT>
<HR>We would be glad to have 
<A HREF='mailto:dba_requests@barryw.org?subject=Comments on Security for a Data Warehouse'>your comments</A>.
<BR><BR><A HREF="teradata_security_links.htm">Another page</A> lists some Security-related links on the Teradata Web Site.

<BR><BR>In the diagram, the section entitled 'Security Policies and Procedures' is from 
<A HREF="http://developer.teradata.com/database/articles/defense-in-depth-best-practices-for-securing-a-teradata-data-warehouse" TARGET=_NEW>the Teradata Web Site</A>.


</TD>
</TR>

<TR>
<TD COLSPAN=2>&nbsp;</TD>
</TR>

<TR>
<TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<IMG ALIGN=middle ALT="Risk Monitoring System and GRC Platform" BORDER=0 VALIGN=top SRC="images/risk_monitoring_system_jpg.jpg"> 
</TD>

<TD ALIGN=left VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
The diagram on the left shows the Risk Monitoring System which is built on a GRC Platform.
<BR><BR>It is designed to be used from an initial Proof-of-Concept ('POC') through to a fully-featured Application.

<BR><BR>The intention is that early facilities that are not sensitive can be demonstrated 'in-the-Clouds' to establish a POC. 
</TD>
</TR>


<!--- man_on_cell_phone_on_beach_sml --->


<TR>
<TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<BR>
<PRE><FONT COLOR=blue FACE=Verdana SIZE=2><B>BI on the Beach</B></PRE> 
<IMG ALIGN=middle ALT="Data Quality" BORDER=0 VALIGN=top SRC="images/man_on_cell_phone_on_beach_lge.jpg"> 
</TD>

<TD ALIGN=left VALIGN=top><PRE><FONT COLOR=blue FACE=Verdana SIZE=2>
The picture on the left shows a CIO who was relaxing on the beach, and is now responding to 
an Alert on his cell/mobile telling him about a breach of security with the Teradata Data Warehouse 
that he needs to respond to.</PRE>
</TD>
</TR>

<!---
<TR>
<TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<BR><FONT COLOR=red><B>This are identical gauges and are shown for demonstration purposes only</B></font>
<PRE><FONT COLOR=blue FACE=Verdana SIZE=2><B>Governance   -----------   Risk   -----------    Compliance</B></PRE> 
<IMG ALIGN=middle ALT="Data Quality" BORDER=0 VALIGN=top SRC="images/melissa_grc_DQ.jpg"> 
<IMG ALIGN=middle ALT="Data Quality" BORDER=0 VALIGN=top SRC="images/melissa_grc_DQ.jpg"> 
<IMG ALIGN=middle ALT="Data Quality" BORDER=0 VALIGN=top SRC="images/melissa_grc_DQ.jpg"> 
</TD>

<TD ALIGN=left VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
The diagram on the left shows the Risk Indicators that make it possible for the CIO to relax in Hawaii thanks to "<B>BI on the Beach</B>" for GRC
<BR> 
<LI><B>Governance</B> = Data Model Quality 
<LI><B>Risk</B> = Unsuccessful Login Attempts 
<LI><B>Compliance</B> = SOX - Data Lineage
</TD>
</TR>

<TR>
<TD ALIiiiGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>
<FONT COLOR=red><B>This is a draft and is not completed</B></font>
<PRE><FONT COLOR=blue FACE=Verdana SIZE=2><B>
Governance   -----------   Risk   --------------    Compliance</B>
Data Model Quality=80%   Unsuccessful Logins       Data Lineage for SOX       
Ent Data Model - 90%     Hourly distrubution of      Revenue    Costs   Deliveries   
Subject Area 1 - 80%     of totals,IP Addresses         |            |         |
Subject Area 2 - 70%     ----------------------         |          --         --
Subject Area 3 - 70%                                          |     
--------------------                                           v
                                                                  POS
</PRE> 

<BR><BR>
</TD>

<TD ALIGN=left VALIGN=top><PRE><FONT COLOR=blue FACE=Verdana SIZE=2>
On the left we show drill-down for G,R and C.
For G, we drill-down to the % scores for each Model.
For R, we monitor Unsuccessful Login Attemps, and we drill-down to 
       totals by Hourly distribution and IP Addresses.
For C, we monitor how far we can drill-down to show Data Lineage in 
       compliance with Sarbanes-Oxley.
       Drill-down reflects this and for Revenues, we assume that we can drill-down 100%, to the POS System from the Store.
For </PRE>
</TD>
</TR>
--->

</TABLE>

<BR>Barry Williams
<BR>Principal Consultant
<BR>Database Answers Ltd.
<BR>London, England
<BR>November 28th. 2012
<BR>
</td>
</tr>
</table>

<CENTER><FONT COLOr=blue FACE=Verdana SIZE=1>
<BR><BR><I> &#169 DataBase Answers Ltd. 2012</I></FONT>
</CENTER>

</TD>
</TR>
</TABLE>

<!--- START OF MAY 21ST. BOTTOM MENU BAR --->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="32" background="images/nav_bg.jpg" align="left" valign="middle">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
	<td width="80%"><img src="images/spacer.gif" width="80" height="15"></td>
	<td align=LEFT WIDTH=10%><A STYLE="text-decoration:none" HREF="about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A>
</td>

	<td align=LEFT WIDTH=15%><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A>
	</td>
        </tr>
      </table>
    </td>
  </tr>
</table>

<!--- END OF MAY 21st. BOTTOM MENU BAR --->

<!-- HERE BASE TABLE CLOSES, INSIDE WHICH ALL PAGE IS PLACED, AND WHICH WIDTH IS 90 PERCENTS --> 
</td>
</tr>
</table>

<div>
<map id="teradata_data_security_architecture" name="teradata_data_security_architecture">
<area shape="rect" alt="Teradata's Data Warehouse Governance" coords="32,49,452,230" href="http://apps.teradata.com/tdmo/v08n01/FactsAndFun/Services/TeamWorks.aspx" title="Teradata's Data Warehouse Governance"/ TARGET=_NEW>
<area shape="rect" alt="Teradata's Best Practice for Securing a Data Warehouse" coords="96,364,392,592" href="http://developer.teradata.com/database/articles/defense-in-depth-best-practices-for-securing-a-teradata-data-warehouse" title="Teradata's Best Practice for Securing a Data Warehouse"/ TARGET=_NEW>
<area shape="default" nohref="nohref" alt="" />
</map>
</div>
</body>

</html>