Create ACL - Intergraph Smart Materials - Version 10.2 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.2

Before the database can access the license webservice, it is required to enter the hostname of the license webservice in the access control list (ACL). Maintaining the ACL is a DBA task. You can create an ACL for the licensing or you can use an existing one. To create an ACL, do the following:

  1. Open a Command Prompt window.

  2. Launch a SQL*Plus session.

  3. Connect as M_SYS.

  4. Perform this command to create the access control list:

    Exec DBMS_NETWORK_ACL_ADMIN.create_acl ('LicenseWebservice.xml','Access control list for the session-based-check-SmartLicensing','M_SYS',TRUE,'connect',NULL,NULL);

    with these parameters:

    acl

    'LicenseWebservice.xml'

    description

    'Access control list for the License Webservice'

    principal

    'M_SYS'

    is_grant

    TRUE

    privilege

    'connect'

    start_date

    NULL

    end_date

    NULL

    The xml file name of the access control list is a sample. You may choose a different name.

  5. Once the ACL got created, you can assign all hostnames you want to allow. Assume your license webservice uses the following URL:

    <myWebserver>/SmartMaterialsLicenseWebservice<SMatVersion>/SmartLicensingService/service/home

    Replace <myWebserver> with your hostname (which might include domain name and port specification) and <SMatVersion> with the version of Smart Materials License Webservice version.

    The first token one is the hostname. With this token, you would perform the following command:

    exec DBMS_NETWORK_ACL_ADMIN.assign_acl ('LicenseWebservice.xml','myWebserver',NULL,NULL);

    with these parameters:

    acl

    'LicenseWebservice.xml'

    host

    'myWebserver'

    lower_port

    NULL

    upper_port

    NULL

    This enables the database to contact the remote node. If you need to include the domain name in the URL, you also need to include it in the assign_acl command. If you want to go by IP-address, assign the IP address.

  6. To check which ACL file is currently saved in the database, use this command:

    select * from dba_network_acls;