2 <html lang="en-us" itemscope itemtype="http://schema.org/Article">
5 <meta name="description" content=" 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...">
6 <meta name="generator" content="Movable Type 5.2.3">
7 <title>LDAP changes/Synonyms and Grants/Reports - Status</title>
8 <link rel="alternate" type="application/atom+xml" title="Recent Entries" href="http://defaria.com/blogs/Status/atom.xml">
9 <link rel="canonical" href="http://defaria.com/blogs/Status/2007/05/ldap-changes.html">
10 <meta name="viewport" content="width=device-width,initial-scale=1">
11 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles.css">
13 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles_ie.css">
14 <script src="/mt/mt-static/support/theme_static/rainier/js/html5shiv.js"></script>
17 <link rel="start" href="http://defaria.com/blogs/Status/">
19 <link rel="prev" href="http://defaria.com/blogs/Status/2007/05/gpdbldaporgsbe.html" title="GPDB/LDAP/Org/SBE">
20 <link rel="next" href="http://defaria.com/blogs/Status/2007/05/gpdb-enhancemen-2.html" title="GPDB Enhancements">
21 <!-- Open Graph Protocol -->
22 <meta property="og:type" content="article">
23 <meta property="og:locale" content="en-us">
24 <meta property="og:title" content="LDAP changes/Synonyms and Grants/Reports">
25 <meta property="og:url" content="http://defaria.com/blogs/Status/2007/05/ldap-changes.html">
26 <meta property="og:description" content=" 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...">
27 <meta property="og:site_name" content="Status">
28 <meta property="og:image" content="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
30 <meta itemprop="description" content=" 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...">
31 <link itemprop="url" href="http://defaria.com/blogs/Status/2007/05/ldap-changes.html">
32 <link itemprop="image" href="/mt/mt-static/support/theme_static/rainier/img/siteicon-sample.png">
37 <div id="container-inner">
38 <header id="header" role="banner">
39 <div id="header-inner">
40 <div id="header-content">
42 <a href="http://defaria.com/blogs/Status/">
51 <nav role="navigation">
53 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
62 <div id="content-inner">
63 <ul class="breadcrumb breadcrumb-list">
64 <li class="breadcrumb-list-item"><a href="http://defaria.com/blogs/Status/">Home</a></li>
65 <li class="breadcrumb-list-item">LDAP changes/Synonyms and Grants/Reports</li>
67 <div id="individual-main" class="main" role="main">
68 <article id="entry-1888" class="entry entry-asset asset hentry">
69 <div class="asset-header">
70 <h2 itemprop="name" class="asset-name entry-title">LDAP changes/Synonyms and Grants/Reports</h2>
71 <footer class="asset-meta">
72 <ul class="asset-meta-list">
73 <li class="asset-meta-list-item">Posted on <time datetime="2007-05-04T14:35:52-08:00" itemprop="datePublished">May 4, 2007</time></li>
74 <li class="asset-meta-list-item">by <span class="author entry-author vcard"></span></li>
77 <li class="asset-meta-list-item">in <a itemprop="articleSection" rel="tag" href="http://defaria.com/blogs/Status/gpdb/">GPDB</a></li>
83 <div class="entry-content asset-content" itemprop="articleBody">
85 <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>
87 <li>Straightened out new views WRT Synonyms and Grants</li>
89 <li>Implemented Users, Clearcase and DesignSync reports</li>
91 <h2>Synonyms and Grants</h2>
93 <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>
95 <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>
97 <p>So then the sequence is:</p>
100 <li>Create the table or view</li>
102 <div class=code><pre>
103 create or replace view foo ...
106 <li>Grant select privileges to the table or view:</li>
108 <div class=code><pre>
109 grant select to foo on cm_gpdb.foo for cm_gpdb_readonly
112 <li>Log into Oracle database as other user and create synonym:</li>
114 <div class=code><pre>
115 create or replace synonym foo for cm_gpdb.foo
122 <li>The database's schema name for GPDB is cm_gpdb above</li>
124 <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>
127 <nav class="page-navigation entry-navigation pagination content-nav">
128 <ul class="page-navigation-list">
130 <li class="page-navigation-list-item page-navigation-prev"><a rel="prev" href="http://defaria.com/blogs/Status/2007/05/gpdbldaporgsbe.html" title="GPDB/LDAP/Org/SBE">Previous entry</a></li>
133 <li class="page-navigation-list-item page-navigation-next"><a rel="next" href="http://defaria.com/blogs/Status/2007/05/gpdb-enhancemen-2.html" title="GPDB Enhancements">Next entry</a></li>
138 <aside id="zenback" class="zenback feedback">
139 Please paste Zenback script code here.
146 <aside class="widgets related" role="complementary">
147 <nav class="widget-search widget">
148 <div class="widget-content">
149 <form method="get" id="search" action="http://defaria.com/mt/mt-search.cgi">
151 <input type="text" name="search" value="" placeholder="Search...">
153 <input type="hidden" name="IncludeBlogs" value="8">
155 <input type="hidden" name="limit" value="20">
156 <button type="submit" name="button">
157 <img alt="Search" src="/mt/mt-static/support/theme_static/rainier/img/search-icon.png">
163 <nav class="widget-archive-category widget">
164 <h3 class="widget-header">Categories</h3>
165 <div class="widget-content">
168 <ul class="widget-list">
171 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/ameriquest/">Ameriquest (99)</a>
179 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/audience/">Audience (3)</a>
187 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/broadcom/">Broadcom (76)</a>
195 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/gpdb/">GPDB (35)</a>
203 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-dynamics/">General Dynamics (61)</a>
211 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/general-electric/">General Electric (13)</a>
219 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/hewlett-packard/">Hewlett Packard (13)</a>
227 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/lynuxworks/">LynuxWorks (162)</a>
235 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/pqa/">PQA (35)</a>
243 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/salira/">Salira (79)</a>
251 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/tellabs/">Tellabs (2)</a>
259 <li class="widget-list-item"><a href="http://defaria.com/blogs/Status/texas-instruments/">Texas Instruments (31)</a>
271 <nav class="widget-archive-dropdown widget">
272 <h3 class="widget-header">Archives</h3>
273 <div class="widget-content">
275 <option>Select a Month...</option>
277 <option value="http://defaria.com/blogs/Status/2016/02/">February 2016</option>
281 <option value="http://defaria.com/blogs/Status/2014/09/">September 2014</option>
285 <option value="http://defaria.com/blogs/Status/2014/04/">April 2014</option>
289 <option value="http://defaria.com/blogs/Status/2014/03/">March 2014</option>
293 <option value="http://defaria.com/blogs/Status/2013/02/">February 2013</option>
297 <option value="http://defaria.com/blogs/Status/2012/09/">September 2012</option>
301 <option value="http://defaria.com/blogs/Status/2012/08/">August 2012</option>
305 <option value="http://defaria.com/blogs/Status/2012/05/">May 2012</option>
309 <option value="http://defaria.com/blogs/Status/2012/04/">April 2012</option>
313 <option value="http://defaria.com/blogs/Status/2012/02/">February 2012</option>
317 <option value="http://defaria.com/blogs/Status/2012/01/">January 2012</option>
321 <option value="http://defaria.com/blogs/Status/2011/10/">October 2011</option>
325 <option value="http://defaria.com/blogs/Status/2011/07/">July 2011</option>
329 <option value="http://defaria.com/blogs/Status/2010/09/">September 2010</option>
333 <option value="http://defaria.com/blogs/Status/2010/08/">August 2010</option>
337 <option value="http://defaria.com/blogs/Status/2010/04/">April 2010</option>
341 <option value="http://defaria.com/blogs/Status/2010/03/">March 2010</option>
345 <option value="http://defaria.com/blogs/Status/2010/02/">February 2010</option>
349 <option value="http://defaria.com/blogs/Status/2009/05/">May 2009</option>
353 <option value="http://defaria.com/blogs/Status/2009/04/">April 2009</option>
357 <option value="http://defaria.com/blogs/Status/2008/07/">July 2008</option>
361 <option value="http://defaria.com/blogs/Status/2008/05/">May 2008</option>
365 <option value="http://defaria.com/blogs/Status/2008/04/">April 2008</option>
369 <option value="http://defaria.com/blogs/Status/2008/03/">March 2008</option>
373 <option value="http://defaria.com/blogs/Status/2008/02/">February 2008</option>
377 <option value="http://defaria.com/blogs/Status/2008/01/">January 2008</option>
381 <option value="http://defaria.com/blogs/Status/2007/12/">December 2007</option>
385 <option value="http://defaria.com/blogs/Status/2007/11/">November 2007</option>
389 <option value="http://defaria.com/blogs/Status/2007/10/">October 2007</option>
393 <option value="http://defaria.com/blogs/Status/2007/09/">September 2007</option>
397 <option value="http://defaria.com/blogs/Status/2007/08/">August 2007</option>
401 <option value="http://defaria.com/blogs/Status/2007/07/">July 2007</option>
405 <option value="http://defaria.com/blogs/Status/2007/06/">June 2007</option>
409 <option value="http://defaria.com/blogs/Status/2007/05/">May 2007</option>
413 <option value="http://defaria.com/blogs/Status/2007/04/">April 2007</option>
417 <option value="http://defaria.com/blogs/Status/2007/03/">March 2007</option>
421 <option value="http://defaria.com/blogs/Status/2007/01/">January 2007</option>
425 <option value="http://defaria.com/blogs/Status/2006/12/">December 2006</option>
429 <option value="http://defaria.com/blogs/Status/2006/11/">November 2006</option>
433 <option value="http://defaria.com/blogs/Status/2006/10/">October 2006</option>
437 <option value="http://defaria.com/blogs/Status/2006/09/">September 2006</option>
441 <option value="http://defaria.com/blogs/Status/2006/07/">July 2006</option>
445 <option value="http://defaria.com/blogs/Status/2006/06/">June 2006</option>
449 <option value="http://defaria.com/blogs/Status/2006/05/">May 2006</option>
453 <option value="http://defaria.com/blogs/Status/2006/04/">April 2006</option>
457 <option value="http://defaria.com/blogs/Status/2006/03/">March 2006</option>
461 <option value="http://defaria.com/blogs/Status/2006/02/">February 2006</option>
465 <option value="http://defaria.com/blogs/Status/2006/01/">January 2006</option>
469 <option value="http://defaria.com/blogs/Status/2005/12/">December 2005</option>
473 <option value="http://defaria.com/blogs/Status/2005/11/">November 2005</option>
477 <option value="http://defaria.com/blogs/Status/2005/10/">October 2005</option>
481 <option value="http://defaria.com/blogs/Status/2005/09/">September 2005</option>
485 <option value="http://defaria.com/blogs/Status/2005/08/">August 2005</option>
489 <option value="http://defaria.com/blogs/Status/2005/07/">July 2005</option>
493 <option value="http://defaria.com/blogs/Status/2005/06/">June 2005</option>
497 <option value="http://defaria.com/blogs/Status/2005/05/">May 2005</option>
501 <option value="http://defaria.com/blogs/Status/2005/04/">April 2005</option>
505 <option value="http://defaria.com/blogs/Status/2005/03/">March 2005</option>
509 <option value="http://defaria.com/blogs/Status/2005/02/">February 2005</option>
513 <option value="http://defaria.com/blogs/Status/2005/01/">January 2005</option>
517 <option value="http://defaria.com/blogs/Status/2004/12/">December 2004</option>
521 <option value="http://defaria.com/blogs/Status/2004/09/">September 2004</option>
525 <option value="http://defaria.com/blogs/Status/2004/08/">August 2004</option>
529 <option value="http://defaria.com/blogs/Status/2004/07/">July 2004</option>
533 <option value="http://defaria.com/blogs/Status/2004/06/">June 2004</option>
537 <option value="http://defaria.com/blogs/Status/2004/05/">May 2004</option>
541 <option value="http://defaria.com/blogs/Status/2004/04/">April 2004</option>
545 <option value="http://defaria.com/blogs/Status/2004/03/">March 2004</option>
549 <option value="http://defaria.com/blogs/Status/2004/02/">February 2004</option>
553 <option value="http://defaria.com/blogs/Status/2004/01/">January 2004</option>
557 <option value="http://defaria.com/blogs/Status/2003/12/">December 2003</option>
561 <option value="http://defaria.com/blogs/Status/2003/11/">November 2003</option>
569 <div class="widget-syndication widget section">
570 <div class="widget-content">
571 <p><img src="http://defaria.com/mt/mt-static/images/status_icons/feed.gif" alt="Subscribe to feed" width="9" height="9" /> <a href="http://defaria.com/blogs/Status/atom.xml">Subscribe to this blog's feed</a></p>
579 <footer id="footer" role="contentinfo">
580 <div id="footer-inner">
581 <div id="footer-content">
582 <nav role="navigation">
584 <li><a href="http://defaria.com/blogs/Status/">Home</a></li>
590 <p class="license">© Copyright 2016.</p>
591 <p class="poweredby">Powered by <a href="http://www.movabletype.org/">Movable Type</a></p>
597 <script src="http://defaria.com/mt/mt-static/jquery/jquery.min.js"></script>
598 <script src="http://defaria.com/blogs/Status/mt-theme-scale2.js"></script>