defaria.com/blogs/Status/archives/week_2007_04_29.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: April 29, 2007 - May  5, 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_04_15.html" title="April 15, 2007 - April 21, 2007" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2007_05_06.html" title="May  6, 2007 - May 12, 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_04_15.html">&laquo; April 15, 2007 - April 21, 2007</a> |
  36                         <a href="http://defaria.com/blogs/Status/">Main</a>
  37                         | <a href="http://defaria.com/blogs/Status/archives/week_2007_05_06.html">May  6, 2007 - May 12, 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_04_29.html#entry-000640"
  47     trackback:ping="http://defaria.com/mt/mt-tb.cgi/28"
  48     dc:title="LDAP changes/Synonyms and Grants/Reports"
  49     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000640"
  50     dc:subject="GPDB"
  51     dc:description=" Change primitives::login and ldap_authenticate to return a user record of user information if we can find it in LDAP, even if we could not authenticate the password, and pass back proper status Straightened out new views WRT Synonyms and..."
  52     dc:creator=""
  53     dc:date="2007-05-04T14:35:52-06:00" />
  54 </rdf:RDF>
  55 -->
  56
  57
  58                      <h2 class="date-header">May  4, 2007</h2>
  59                      <a id="a000640"></a>
  60                      <div class="entry" id="entry-640">
  61                         <h3 class="entry-header">LDAP changes/Synonyms and Grants/Reports</h3>
  62                         <div class="entry-content">
  63                            <div class="entry-body">
  64                               <ul>
  65   <li>Change primitives::login and ldap_authenticate to return a user record of user information if we can find it in LDAP, even if we could not authenticate the password, and pass back proper status</li>
  66
  67   <li>Straightened out new views WRT Synonyms and Grants</li>
  68
  69   <li>Implemented Users, Clearcase and DesignSync reports</li>
  70 </ul>
  71
  72                               <h2>Synonyms and Grants</h2>
  73
  74 <p>When one creates a table or view in Oracle it appears to be "private" to the user who has created it. Others can get to the table but they need to specify a more qualified name. Additionally the need to have been granted access to it (at least select access).</p>
  75
  76 <p>So if we create a view, say foo, we also need to grant select access to those tables to the other users who might be using it. Additionally, in GPDB we have 3 DB level usernames: cm_gpdb, cm_gpdb_readonly and cm_gpdb_update. So if we create the view foo while logged in as cm_gpdb then login as say cm_gpdb_readonly, this new session will not be able to see foo.</p>
  77
  78 <p>So then the sequence is:</p>
  79
  80 <ol>
  81   <li>Create the table or view</li>
  82
  83 <div class=code><pre>
  84 create or replace view foo ...
  85 </pre></div>
  86
  87   <li>Grant select privileges to the table or view:</li>
  88
  89 <div class=code><pre>
  90 grant select to foo on cm_gpdb.foo for cm_gpdb_readonly
  91 </pre></div>
  92
  93   <li>Log into Oracle database as other user and create synonym:</li>
  94
  95 <div class=code><pre>
  96 create or replace synonym foo for cm_gpdb.foo
  97 </pre></div>
  98 </ol>
  99
 100 <h4>Notes</h4>
 101
 102 <ol>
 103   <li>The database's schema name for GPDB is cm_gpdb above</li>
 104
 105   <li>Grants need to be done whenever the table or view is recreated. Synonyms, being pointers, need to be created only when a new pointer is needed</li>
 106 </ol>
 107
 108                               <p class="entry-footer">
 109                                  <span class="post-footers">Posted by  at  2:35 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000640.html">Permalink</a>
 110
 111                                  | <a href="http://defaria.com/blogs/Status/archives/000640.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_04_29.html#entry-000639"
 123     trackback:ping="http://defaria.com/mt/mt-tb.cgi/27"
 124     dc:title="GPDB/LDAP/Org/SBE"
 125     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000639"
 126     dc:subject="GPDB"
 127     dc:description=" Added Org/SBE drop down to edit Project Integrated LDAP! Changed primitive.pm to authenticate with LDAP! Added description to Org/SBE and removed password Added edit links to showProject and showSite..."
 128     dc:creator=""
 129     dc:date="2007-05-03T18:45:32-06:00" />
 130 </rdf:RDF>
 131 -->
 132
 133
 134                      <h2 class="date-header">May  3, 2007</h2>
 135                      <a id="a000639"></a>
 136                      <div class="entry" id="entry-639">
 137                         <h3 class="entry-header">GPDB/LDAP/Org/SBE</h3>
 138                         <div class="entry-content">
 139                            <div class="entry-body">
 140                               <ul>
 141   <li>Added Org/SBE drop down to edit Project</li>
 142
 143   <li>Integrated LDAP!</li>
 144
 145   <li>Changed primitive.pm to authenticate with LDAP!</p>
 146
 147   <li>Added description to Org/SBE and removed password</li>
 148
 149   <li>Added edit links to showProject and showSite</li>
 150 </ul>
 151
 152                               <p class="entry-footer">
 153                                  <span class="post-footers">Posted by  at  6:45 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000639.html">Permalink</a>
 154
 155                                  | <a href="http://defaria.com/blogs/Status/archives/000639.html#trackback">TrackBacks (0)</a>
 156                               </p>
 157                            </div>
 158                         </div>
 159                      </div>
 160
 161                      <!--
 162 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 163          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 164          xmlns:dc="http://purl.org/dc/elements/1.1/">
 165 <rdf:Description
 166     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000638"
 167     trackback:ping="http://defaria.com/mt/mt-tb.cgi/26"
 168     dc:title="GPDB (Org/SBE and others)"
 169     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000638"
 170     dc:subject="GPDB"
 171     dc:description=" Changed org_sbe.name to link up with parent_project Created org_sbe.sql to add org_sbe entries Added gpdb_getOrgSBE and gpdb_putOrgSBE to gpdb.pm Added Org/SBE menu Changed various new tables to to be uniform in width Fixed a few bugs regarding adding of..."
 172     dc:creator=""
 173     dc:date="2007-05-03T09:46:24-06:00" />
 174 </rdf:RDF>
 175 -->
 176
 177
 178
 179                      <a id="a000638"></a>
 180                      <div class="entry" id="entry-638">
 181                         <h3 class="entry-header">GPDB (Org/SBE and others)</h3>
 182                         <div class="entry-content">
 183                            <div class="entry-body">
 184                               <ul>
 185   <li>Changed org_sbe.name to link up with parent_project</li>
 186
 187   <li>Created org_sbe.sql to add org_sbe entries</li>
 188
 189   <li>Added gpdb_getOrgSBE and gpdb_putOrgSBE to gpdb.pm</li>
 190
 191   <li>Added Org/SBE menu</li>
 192
 193   <li>Changed various new tables to to be uniform in width</li>
 194
 195   <li>Fixed a few bugs regarding adding of sites where no site domains are added</li>
 196
 197   <li>Added much of Update Project</li>
 198
 199   <li>Fixed bug with update CCDefaults for Projects</li>
 200
 201   <li>Added screen for adding CCDefaults when adding a project</li>
 202 </ul>
 203
 204                               <p class="entry-footer">
 205                                  <span class="post-footers">Posted by  at  9:46 AM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000638.html">Permalink</a>
 206
 207                                  | <a href="http://defaria.com/blogs/Status/archives/000638.html#trackback">TrackBacks (0)</a>
 208                               </p>
 209                            </div>
 210                         </div>
 211                      </div>
 212
 213                      <!--
 214 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 215          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 216          xmlns:dc="http://purl.org/dc/elements/1.1/">
 217 <rdf:Description
 218     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000637"
 219     trackback:ping="http://defaria.com/mt/mt-tb.cgi/25"
 220     dc:title="GPDB Enhancements/Fixes"
 221     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000637"
 222     dc:subject="GPDB"
 223     dc:description="GPDB Login Moved to the top. Changed wording to be more friendly Login with unknown username puts up a warning but grants read only access Login with known username but wrong password is properly denoted Other changes In Project display,..."
 224     dc:creator=""
 225     dc:date="2007-05-01T19:25:50-06:00" />
 226 </rdf:RDF>
 227 -->
 228
 229
 230                      <h2 class="date-header">May  1, 2007</h2>
 231                      <a id="a000637"></a>
 232                      <div class="entry" id="entry-637">
 233                         <h3 class="entry-header">GPDB Enhancements/Fixes</h3>
 234                         <div class="entry-content">
 235                            <div class="entry-body">
 236                               <h3>GPDB Login</h3>
 237
 238 <ul>
 239   <li>Moved to the top.</li>
 240   <li>Changed wording to be more friendly</li>
 241   <li>Login with unknown username puts up a warning but grants read
 242 only access</li>
 243   <li>Login with known username but wrong password is properly denoted</li>
 244 </ul>
 245
 246 <h3>Other changes</h3>
 247
 248 <ul>
 249   <li>In Project display, site defaults are not listed on top of the
 250 Project defaults.</li>
 251
 252   <li>Change width of tables to line up with the menus across the top.</li>
 253
 254   <li>Updating of project CC defaults still not working correctly</li>
 255
 256   <li>Added Add Project</li>
 257 </ul>
 258
 259
 260                               <p class="entry-footer">
 261                                  <span class="post-footers">Posted by  at  7:25 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000637.html">Permalink</a>
 262
 263                                  | <a href="http://defaria.com/blogs/Status/archives/000637.html#trackback">TrackBacks (0)</a>
 264                               </p>
 265                            </div>
 266                         </div>
 267                      </div>
 268
 269                      <!--
 270 <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
 271          xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"
 272          xmlns:dc="http://purl.org/dc/elements/1.1/">
 273 <rdf:Description
 274     rdf:about="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000636"
 275     trackback:ping="http://defaria.com/mt/mt-tb.cgi/24"
 276     dc:title="GPDB Enhancements/Fixes"
 277     dc:identifier="http://defaria.com/blogs/Status/archives/week_2007_04_29.html#entry-000636"
 278     dc:subject="GPDB"
 279     dc:description=" Implemented gpdb_deleteSiteDomain Modify site almost functionally complete Looking into how to do what MySQL does with it&apos;s limit clause in Oracle Changed List Projects at Site to be paged Changed how Projects are displayed Added most of the Project..."
 280     dc:creator=""
 281     dc:date="2007-04-30T14:58:37-06:00" />
 282 </rdf:RDF>
 283 -->
 284
 285
 286                      <h2 class="date-header">April 30, 2007</h2>
 287                      <a id="a000636"></a>
 288                      <div class="entry" id="entry-636">
 289                         <h3 class="entry-header">GPDB Enhancements/Fixes</h3>
 290                         <div class="entry-content">
 291                            <div class="entry-body">
 292                               <ul>
 293   <li>Implemented gpdb_deleteSiteDomain</li>
 294   <li>Modify site almost functionally complete</li>
 295   <li>Looking into how to do what MySQL does with it's limit clause in
 296 Oracle</li>
 297   <li>Changed List Projects at Site to be paged</li>
 298   <li>Changed how Projects are displayed </li>
 299   <li>Added most of the Project update page</li>
 300   <li>Change some of the logic on login/logout</li>
 301   <li>Change gpdb_putClearcase to set a global as to whether the record
 302 was added/updated or nothing changed.</li>
 303   <li>Changed gpdb_add_vob.pl to:</li>
 304   <ul>
 305     <li>Report better the number of Clearcase vob records added or not.</li>
 306   </ul>
 307   <ul>
 308     <li>Add an UNKNOWN project for the site it's running at (if needed)</li>
 309     <li>Properly select the appropriate UNKNOWN project</li>
 310   </ul>
 311 </ul>
 312
 313                               <p class="entry-footer">
 314                                  <span class="post-footers">Posted by  at  2:58 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000636.html">Permalink</a>
 315
 316                                  | <a href="http://defaria.com/blogs/Status/archives/000636.html#trackback">TrackBacks (0)</a>
 317                               </p>
 318                            </div>
 319                         </div>
 320                      </div>
 321
 322                   </div>
 323                </div>
 324             </div>
 325          </div>
 326       </div>
 327    </div>
 328 </body>
 329 </html>