Oracle Enterprise User Security EUS

What is Oracle EUS?
Integrate Oracle EUS with OUD (LINK)

-------------------------------------------------------------------------------------------------------------------

Migration from OID to OUD: Adapting EUS metadata  

By: Guest Author   (https://blogs.oracle.com/sduloutr/migration-from-oid-to-oud%3a-adapting-eus-metadata)  LINK
Enterprise User Security is an important component of Oracle Database Enterprise Edition. It enables you to address administrative and security challenges for a large number of enterprise database users by centralizing users and roles in a LDAP directory.

It is possible to use either Oracle Internet Directory (OID) or Oracle Unified Directory (OUD) as LDAP repository for EUS.

To migrate from OID to OUD, 
- enable EUS support in OUD- copy your user and groups in - copy across EUS metadata (in cn=oracleContext,
EUS metadata as stored in OID must be slighly adapted before being impoorted to OUD otherwise the DB won't be able to authenticate against OUD and will raise the following error:
ORA-28043: invalid bind credentials for DB-OID connection
Migrating the DB entry from OID to OUD requires some specific steps for SASL/DIGEST-MD5 authentication. In OID, the password
hash used for SASL/DIGEST-MD5 authentication is stored in authpassword;oid, with the {SASL/MD5} prefix.

In OUD, this must be stored  in orclcommonrpwdattribute with the
{SASL-MD5} prefix.


For instance:
In OID:

ldapsearch [conn details] -b cn=oraclecontext,dc=example,dc=com
-s one "(cn=orcl11g)" authpassword

dn: cn=orcl11g,cn=oraclecontext,dc=example,dc=com
authpassword;oid: {SASL/MD5}ola+G+GFsSeiu6QcRiAh9g==

authpassword;oid: {SASL/MD5-DN}3UeqmU5Axd+XVAM9Lxf28g==

authpassword;oid: {SASL/MD5-U}BD6uyBcSiFbGtlPzq6TtUA==


In OUD:

ldapsearch [conn details] -b cn=oraclecontext,dc=example,dc=com
-s one "(objectclass=orcldbserver)" orclcommonrpwdattribute

dn: cn=orcl11g,cn=OracleContext,dc=example,dc=com
orclcommonrpwdattribute: {SASL-MD5}ola+G+GFsSeiu6QcRiAh9g==



-----------------------------------------------------------------------------------------------------------

Configuring OUD to Support Multiple Enterprise User Security Domains

By: Guest Author

id="1680" class="segment">Configuring
OUD to Support Multiple Enterprise User Security Domains


id="1681" class="segment">If your users and groups are stored in multiple domains, you must configure OUD to support multiple EUS
domains.class="segment"> For example, a single OUD instance contains two EUS domains.name="OracleReview" id="1683" class="segment">class="Apple-converted-space"> One EUS domain stores users entries in Active Directory belowclass="Apple-converted-space"> dir="ltr" style="font-family: monospace; font-size: 12px;">name="OracleReview" id="1684" class="segment">cn=users,dc=ad1,dc=comname="OracleReview" id="1685" class="segment">.name="OracleReview" id="1686" class="segment">class="Apple-converted-space"> A second EUS domain
stores user entries in a different Active Directory instance
below dir="ltr" style="font-family: monospace; font-size: 12px;">name="OracleReview" id="1687" class="segment">cn=users,dc=ad2,dc=comname="OracleReview" id="1688" class="segment">.name="OracleReview" id="1689" class="segment">class="Apple-converted-space"> You must configure
OUD to support each EUS domain.

id="1690" class="segment">To configure OUD to support multiple
EUS domains:

  1. Configure
    OUD as if the primary domain is the single domain containing
    all your users and groups.
    In this
    example, the primary domain isclass="Apple-converted-space">     dir="ltr" style="font-family: monospace; font-size: 12px;">name="OracleReview" id="1693" class="segment">dc=ad1,dc=comname="OracleReview" id="1694" class="segment">.
  2. Configure
    the secondary domain.
    In this
    example, the secondary domain isclass="Apple-converted-space">     dir="ltr" style="font-family: monospace; font-size: 12px;">name="OracleReview" id="1699" class="segment">dc=ad2,dc=comname="OracleReview" id="1700" class="segment">.
  3. Create a
    new naming context for the EUS domain, which isclass="Apple-converted-space">     dir="ltr" style="font-family: monospace; font-size: 12px;">name="OracleReview" id="1704" class="segment">dc=ad2,dc=comname="OracleReview" id="1705" class="segment">class="Apple-converted-space"> in this
    example.

  4. Update
    the Oracle context with the new naming context.
    1. Create
      an LDIF file.
      In
      the following       dir="ltr" style="font-family: monospace; font-size:
      12px;">class="segment">myconfig.ldifname="OracleReview" id="1712" class="segment">class="Apple-converted-space"> example,
      make the following substitutions:
      • Replaceclass="Apple-converted-space"> dir="ltr" style="font-family: monospace; font-size:
        12px;">class="segment">dc=ad1,dc=comname="OracleReview" id="1715" class="segment">class="Apple-converted-space"> with
        the DN of your first domain.
      • Replaceclass="Apple-converted-space"> dir="ltr" style="font-family: monospace; font-size:
        12px;">class="segment">orclcommonusersearchbasename="OracleReview" id="1718" class="segment">class="Apple-converted-space"> with
        the users location in the secondary domain.
      • id="1719" class="segment">orclcommongroupsearchbasename="OracleReview" id="1720" class="segment">class="Apple-converted-space"> with
        the groups location in the secondary domain.
      dn: cn=Common,cn=Products,cn=OracleContext,dc=ad1,dc=comchangetype: modifyadd: orclcommonusersearchbaseorclcommonusersearchbase: cn=users,dc=ad2,dc=comorclcommongroupsearchbase: cn=groups,dc=ad2,dc=com
    2. Update
      OUD configuration using the LDIF file you created in
      step 4a.
      ldapmodify -h oudhost -p 1389 -D "cn=directory manager" 

-w password -f myconfig.ldif


Comments

Post a Comment

Popular posts from this blog

VMware fix for Invalid manifest and ova file import failed errors

Image
Recently we got a OVA file for a virtual machine. The vendor instructions were to import the ova file in vmware Workstation, Player for Windows/Linux, Fusion for Mac, and VirtualBox as well.  The instructions were to take the available package and launch the VM with VMware workstation. The package contained  Module.mf, Module.ovf and Module-disk.vmdk and a Module.ova file. The .mf and .ovf file were 2 KB each whereas the vmdk was several gigs. The package also contained a Module.ova file which was several gigs as well. OVF           Open Virtualization Format MF             Manifest file VMDK       Virtual Machine Disk OVA           Open Virtualization Appliance The ovf file is a xml file that contains metadata for the ovf package The mf file contains the SHA1 hash codes of all files in the package The vmdk file is the disk image of the virtual machine,  VMware Workstation or VirtualBox. (vmdk format was originally developed by VMware and is an open format now). All of
Read more

SOAPUI - import certificate

Image
Note: SoapUI has two versions, one is open source and second Professional version. The open source can be download here . (confirmed link 12/19/2018). SSL Handshake issue:   There is an Issue in SoapUI version 5.3.0 (and 5.2.0 version) with SSL handshake error. It was resolved by updating below in vmoptions file ( refer here ). However, the error that shows up while trying to load wsdl is "Error loading WSDL" as below The fix is to Enable TLS 1.2 protocol for SOAP/REST calls in SoapUI, by ammending the vmoptions file to add the directive for TLS as (-Dsoapui.https.protocols=TLSv1.2). Refer here . Update: Version 5.5.0 does not have this issue. If you are on 5.3.0 better upgrade to 5.5.0 which is available now (Feb 2019). I had above issue as well as another issue reaching to https endpoint. Upgrade to 5.5.0 resolved issue. Select "Check for updates" under the Help menu and you will get option for upgrade. Select upgrade current version and accept all defaul
Read more

Centrally Managed Users (CMU) - New Feature in Oracle Database 18c

Image
Centrally Managed Users (CMU) Centrally Managed Users or CMU is a new feature introduced since Oracle DB 18c which allows simplified database user management through integration with Microsoft Active Directory (AD). Beginning with Oracle Database release 18c, version 18.1 and later supports direct integration with Microsoft Active Directory (AD) using the new centrally managed users capability. CMU allows the Oracle database to perform user authentication and authorization directly against AD. Benefits of CMU With centrally managed users, users accessing the database can be centrally managed to improve an organization's security posture. An enterprise user (a user in Microsoft Active Directory) can be exclusively mapped to a database account, or many enterprise users (in an Microsoft Active Directory group) can be mapped to a shared account in the database. Microsoft Active Directory groups can also be mapped to a database global role, which provides users with additional privilege
Read more