defaria.com/blogs/Status/archives/week_2007_03_25.html

   1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
   2    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   8    <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
   9    <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
  10    <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
  11
  12    <title>Status for Andrew DeFaria: March 25, 2007 - March 31, 2007 Archives</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2007_03_18.html" title="March 18, 2007 - March 24, 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2007_04_08.html" title="April  8, 2007 - April 14, 2007" />
  17 </head>
  18 <body class="layout-one-column">
  19    <div id="container">
  20       <div id="container-inner" class="pkg">
  21
  22          <div id="banner">
  23             <div id="banner-inner" class="pkg">
  24                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  25                <h2 id="banner-description">Searchable status reports and work log</h2>
  26             </div>
  27          </div>
  28
  29          <div id="pagebody">
  30             <div id="pagebody-inner" class="pkg">
  31                <div id="alpha">
  32                   <div id="alpha-inner" class="pkg">
  33
  34                      <p class="content-nav">
  35                         <a href="http://defaria.com/blogs/Status/archives/week_2007_03_18.html">&laquo; March 18, 2007 - March 24, 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2007_04_08.html">April  8, 2007 - April 14, 2007 &raquo;</a>
  38                      </p>
  39
  40
  41                      <!--
  42 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  43          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  44          xmlns:dc="http://purl.org/dc/elements/1.1/">
  45 <rdf:Description
  46     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_03_25.html#entry-000628"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/17"
  48     dc:title="DLPActivity.pl/YELL"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_25.html#entry-000628"
  50     dc:subject="Texas Instruments"
  51     dc:description=" Rewrote DLPAcctivity.pl, a Clearquest reporting tool that emails DLP engineers about Clearquest defects Look into YELL scripts..."
  52     dc:creator=""
  53     dc:date="2007-03-30T17:07:21-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">March 30, 2007</h2>
  59                      <a id="a000628"></a>
  60                      <div class="entry" id="entry-628">
  61                         <h3 class="entry-header">DLPActivity.pl/YELL</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <li>Rewrote DLPAcctivity.pl, a Clearquest reporting tool that emails DLP engineers about Clearquest defects</li>
  66
  67   <li>Look into YELL scripts</li>
  68 </ul>
  69
  70                               <p class="entry-footer">
  71                                  <span class="post-footers">Posted by  at  5:07 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000628.html">Permalink</a>
  72
  73                                  | <a href="http://defaria.com/blogs/Status/archives/000628.html#trackback">TrackBacks (0)</a>
  74                               </p>
  75                            </div>
  76                         </div>
  77                      </div>
  78
  79                      <!--
  80 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
  81          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
  82          xmlns:dc="http://purl.org/dc/elements/1.1/">
  83 <rdf:Description
  84     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_03_25.html#entry-000627"
  85     trackback:ping="http://defaria.com/mt/mt-tb.cgi/16"
  86     dc:title="mkview_linked/GPDB Login"
  87     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_25.html#entry-000627"
  88     dc:subject="Texas Instruments"
  89     dc:description=" Finished work on mkview_linked for MySQL databasse Implemented login for GPDB with cookies..."
  90     dc:creator=""
  91     dc:date="2007-03-28T17:03:40-06:00" />
  92 </rdf:RDF>
  93 -->
  94
  95
  96                      <h2 class="date-header">March 28, 2007</h2>
  97                      <a id="a000627"></a>
  98                      <div class="entry" id="entry-627">
  99                         <h3 class="entry-header">mkview_linked/GPDB Login</h3>
 100                         <div class="entry-content">
 101                            <div class="entry-body">
 102                               <ul>
 103   <li>Finished work on mkview_linked for MySQL databasse</li>
 104
 105   <li>Implemented login for GPDB with cookies</li>
 106 </ul>
 107
 108                               <p class="entry-footer">
 109                                  <span class="post-footers">Posted by  at  5:03 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000627.html">Permalink</a>
 110
 111                                  | <a href="http://defaria.com/blogs/Status/archives/000627.html#trackback">TrackBacks (0)</a>
 112                               </p>
 113                            </div>
 114                         </div>
 115                      </div>
 116
 117                      <!--
 118 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 119          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 120          xmlns:dc="http://purl.org/dc/elements/1.1/">
 121 <rdf:Description
 122     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_03_25.html#entry-000626"
 123     trackback:ping="http://defaria.com/mt/mt-tb.cgi/15"
 124     dc:title="GPDB Login"
 125     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_03_25.html#entry-000626"
 126     dc:subject="GPDB"
 127     dc:description=" Started implementing a login facility for GPDB..."
 128     dc:creator=""
 129     dc:date="2007-03-26T16:57:06-06:00" />
 130 </rdf:RDF>
 131 -->
 132
 133
 134                      <h2 class="date-header">March 26, 2007</h2>
 135                      <a id="a000626"></a>
 136                      <div class="entry" id="entry-626">
 137                         <h3 class="entry-header">GPDB Login</h3>
 138                         <div class="entry-content">
 139                            <div class="entry-body">
 140                               <ul>
 141   <li>Started implementing a login facility for GPDB</li>
 142 </ul>
 143
 144                               <p>Just about the time we were getting the <em>Single Signon</em> working I realized that we also have command line or a script based API in which we allow others to call GPDB functionality. Part of that functionality is logging in with gpdb_login. Well since we didn't come through Single Signon nro a web page how do we get the authorization to log into the database? Answer is we don't. Single Signon is only good for web apps where the <b>only</b> way into the application is through the web.</p>
 145
 146 <p>The security guys did mention something about a command line alternative but it didn't seem like it would fit the bill. I believe that it only allows you to authenticate as your currently logged in user. What if, for example, user A wished to connect to GPDB as user B and knows user B's username and password? What when a script wished to login as an admin on behalf of all users. These questions need to be answered.</p>
 147
 148                               <p class="entry-footer">
 149                                  <span class="post-footers">Posted by  at  4:57 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000626.html">Permalink</a>
 150
 151                                  | <a href="http://defaria.com/blogs/Status/archives/000626.html#trackback">TrackBacks (0)</a>
 152                               </p>
 153                            </div>
 154                         </div>
 155                      </div>
 156
 157                   </div>
 158                </div>
 159             </div>
 160          </div>
 161       </div>
 162    </div>
 163 </body>
 164 </html>