{"id":6092,"date":"2013-09-03T13:08:03","date_gmt":"2013-09-03T17:08:03","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=6092"},"modified":"2013-09-03T13:08:03","modified_gmt":"2013-09-03T17:08:03","slug":"retrievable-attributes-in-ovd-11g","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/","title":{"rendered":"Retrievable attributes in OVD 11g"},"content":{"rendered":"<p>This is a continuation to OVD 11g implementation experiences. Please refer to my previous <a href=\"https:\/\/onlineappsdba.com\/index.php\/2013\/08\/27\/implementing-local-store-adapter-in-ovd-11g\/\">post <\/a>for LSA adapter implementation.<\/p>\n<p>We are using AD adapters underneath LSA adapter. There are list of attributes that needs to be returned as part LDAP search query for both AD Users and Groups.<\/p>\n<p>By default OVD will return all\u00a0 the user attributes (NOT NULL) that are part of LDAP entry. However our requirement is to allow only few attributes and forbid the rest.<\/p>\n<p>There is a field in OVD Adapter that let&#8217;s you achieve this.<\/p>\n<ol>\n<li>Login to ODSM Console.<\/li>\n<li>Goto <strong>Adapters<\/strong> tab.<\/li>\n<li>Click on <strong>Adapter<\/strong>.<\/li>\n<li>Click on <strong>Routing<\/strong> tab.<\/li>\n<li>In the <strong>Retrieval attributes<\/strong> field, click Add to select the attributes that you want to return. It is not mandatory to click Add to add all those attributes. It may be time consuming to add say 40 attributes. Therefore the easiest approach is to write all attributes in a notepad with each attribute separated by line and copy it to the Retrievable Attributes text box. Please refer the below screenshot<a href=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-6093\" src=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif\" alt=\"\" width=\"494\" height=\"398\" srcset=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif 494w, https:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test-300x241.gif 300w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/a>.<\/li>\n<li>Click Apply.<\/li>\n<li>Observe that the order of the attributes may get changed.<\/li>\n<\/ol>\n<p>Run an ldap search to look for all the returning attributes, refer the below example.<\/p>\n<p>.\/ldapsearch -h host -p port -D credential -w pwd -b &#8220;user search base&#8221; -s sub &#8220;cn=JDoe&#8221;<\/p>\n<p>If you have a requirement to forbid few set of attributes from ldap search then you can specify those attributes in <strong>Unretrievable Attributes<\/strong> field.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a continuation to OVD 11g implementation experiences. Please refer to my previous post for LSA adapter implementation. We [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[371],"tags":[357],"class_list":["post-6092","post","type-post","status-publish","format-standard","hentry","category-ovd","tag-ovd-11g"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Retrievable attributes in OVD 11g -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Retrievable attributes in OVD 11g -\" \/>\n<meta property=\"og:description\" content=\"This is a continuation to OVD 11g implementation experiences. Please refer to my previous post for LSA adapter implementation. We [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-03T17:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/\",\"name\":\"Retrievable attributes in OVD 11g -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif\",\"datePublished\":\"2013-09-03T17:08:03+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Retrievable attributes in OVD 11g\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Retrievable attributes in OVD 11g -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/","og_locale":"en_US","og_type":"article","og_title":"Retrievable attributes in OVD 11g -","og_description":"This is a continuation to OVD 11g implementation experiences. Please refer to my previous post for LSA adapter implementation. We [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/","article_published_time":"2013-09-03T17:08:03+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/","url":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/","name":"Retrievable attributes in OVD 11g -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif","datePublished":"2013-09-03T17:08:03+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2013\/08\/test.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/09\/03\/retrievable-attributes-in-ovd-11g\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Retrievable attributes in OVD 11g"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/6092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=6092"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/6092\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=6092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=6092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=6092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}