Loading policy display names and descriptions

To insert or update display names and descriptions for the various policy related elements, run the acpnlsload script. This script loads the following elements:

<Action_nls>, <Attribute_nls>, <ActionGroup_nls>, <ResourceCategory_nls>, <ResourceGroup_nls>, <Relation_nls>, <Policy_nls>, <PolicyGroup_nls>

  1. Ensure that you have loaded the user access group definitions.
  2. Ensure that you have loaded the main access control policy.
  3. Copy the customized translated policy files to the following directory:

    The customized XML files must conform to the accesscontrolpoliciesnls.dtd file in the following directory:

  4. AIXLinuxSun Solaris Operating EnvironmentLogin as the database user ID.
    Note: The database user ID must have the following permission in order to proceed with the steps:
    • read/write/execute authority to the directories, subdirectories, and files in these directories:
    • read/execute authority to the WC_installdir/bin directory and its files.
  5. From the WC_installdir/bin directory, type the following:

    i5/OSiSeriesAIXSun Solaris Operating EnvironmentLinux./acpnlsload.sh database_namedatabase_userdatabase_user_ passwordnls_policies_xml_fileschema_name
    Windowsacpnlsload.cmd database_namedatabase_userdatabase_user_ passwordnls_Policies_xml_fileschema_name

    where:

    database_name
    (Required) Name of the database in which to load the policy.
    database_user
    (Required) Name of the database user who can connect to the database.
    database_user_password
    (Required) The associated password for the database user.
    nls_policies_xml_file
    (Required) The input policy XML file for your national language that specifies what policy data to load into the database.
    schema_name
    (Optional) The name of target database schema. This name is normally the same as database_user.

    For example:

    i5/OSiSeriesAIXSun Solaris Operating EnvironmentLinux./acpnlsload.sh mall dbuser dbusrpwd defaultaccesscontrolpolicies_en_US.xml
    Windowsacpnlsload.cmd mall dbuser dbusrpwd defaultaccesscontrolpolicies_en_US.xml

  6. Check the acpnlsload.log file. Any errors that may occur while running this script will not appear on the command line.

Notes:

  1. To load the access groups and access control policies, you need to run the following related utilities in this sequence:
    1. acugload (loads the user access group definitions)
    2. acpload (loads the main access control policy)
    3. acpnlsload (loads the display names and descriptions)
  2. If you create customized XML files, you need to copy them into the WC_installdir/xml/policies/xml directory to have them loaded into the databases.
  3. There is a setting in the loading scripts that specifies the following parameter setting while resolving ID's and loading the data to the database: "-maxerror 100000". This means that if there up to 100000 foreign key violations while loading the data, they will be ignored, instead of aborting. This value can be increased or decreased as needed. For example, if you want to stop after one such error, you would change the value to 1.
  4. i5/OSiSeriesIf you create customized XML files, you must use the full path to the DTD in your file. The access control policies DTDs are located in WC_installdir/xml/policies/dtd.
  5. When creating a custom policy, do not alter the defaultAccessControlPolicies_locale.xml file. Use this file as a reference to see the structure when you create a custom policy.

Feedback