Import Dialog

The Import Security Definitions dialog has three tabs. Each tab and menu command available on the dialog serves a unique purpose.

Process
Identify the Secured Input File, select security definitions you want to import, and provide parameters for Security Definition Import processing.
Owners
Change the owner of ACLs you want to import.
Objects
Designate names for the imported security definitions.

File Menu

Set as Default
Save your entries on the Import Security Definitions dialog as the default specifications. The settings for the following options on the Process tab are saved:
  • Allow ACL for nonexistent Optim™ objects
  • Overwrite existing definitions
  • Continue import if error(s)

Tools Menu

The following commands are available from the Tools menu.

Select All Definitions
Select check boxes for all listed security definitions. This command is especially useful when you want to import all or most security definitions.
Deselect All Definitions
Clear the check boxes for all listed security definitions, including shaded and/or selected check boxes.
Show Process Log
Display the Security Import Process Log generated by the last execution of Security Definition Import.

Process Tab

Use the Process tab to identify the Secured Input File, select security definitions for import, and provide parameters for Security Definition Import processing. The tab is populated with defaults you have specified.

Import Security Definitions dialog - Process tab

Definitions

The Import Security Definitions Utility populates the list of security definitions by:

  • Identifying the security definitions in the Secured Input File. If there are no definitions of a specific type (e.g., no FADs), the check box for the definition type is shaded. Otherwise, you can expand the list of definitions of the type by clicking the plus (+) sign.
  • Scanning the Optim Directory and identifying the security definitions in the Secured Input File that exist in the Directory. The check box for each listed definition is selected or not according to the Overwrite existing definitions setting.
    • If Overwrite existing definitions is not selected, the check boxes for the definitions that exist in the current Optim Directory are shaded and selected and are unavailable for Import.
    • If Overwrite existing definitions is selected, all check boxes are cleared and any definition can be selected. If a selected definition exists in the Optim Directory, Security Definition Import overwrites it.
Note: At least one available security definition must be selected to run the Security Definition Import Process.

Import Progress

Statistics detail the current and total number of security definitions imported (by definition type) and the current and total number of errors encountered (the “total” numbers are the composite counts for all Security Definition Import Processes performed in the session). This display is updated during processing. The status bar displays information about the definition being processed.

Secured Input File

Specify a Secured Input File generated by the Security Definition Export Process (for details about creating this file, refer to Exporting Security Definitions).

  • To select from a list of recent file names, click the down arrow or use the browse button. You may also copy a name into the box or type a name directly.
  • If you do not provide a fully qualified path, the path from Personal Options is used.
  • If no path is given in Personal Options, the current drive and directory are assumed.

After a Secured Input File is specified, the Import Security Definitions Validation pop-up is displayed. Type the Password and click OK to access the file.

Import Security Definitions Validation dialog

Allow ACL for non-existent Optim Objects

Indicate if ACLs can be imported without having corresponding secured objects in the Optim Directory. Importing ACLs before corresponding secured objects allows the objects to be secured when they are imported. If secured objects are imported before the corresponding ACLs, the objects are unsecured until the ACLs are imported.

If a corresponding secured object is never imported, the Optim Directory will contain ACLs that do not secure an object (orphan ACLs). If an object is created with a name that matches an orphan ACL, that ACL will be associated with the object.

  • To import ACLs for secured objects that do not exist in the Optim Directory, select this check box.
  • To prevent importing ACLs for secured objects that do not exist in the Optim Directory, clear the check box.

Overwrite existing definitions

Indicate the action taken when the name of an imported security definition matches a definition already in the current Optim Directory:

  • To overwrite existing definitions in the Directory and select any or all security definitions for import, select the check box.
  • To prevent overwriting security definitions, clear the check box. Duplicate definitions, indicated by check boxes that are shaded and selected, are not imported.

Continue import if error(s)

Indicate processing if an error occurs. Errors are written to the Security Import Process Log and displayed on the message bar.

  • To continue processing if an error occurs, select the check box.
  • To halt processing if an error occurs, clear the check box.

Owners Tab

Use the Owners tab to review or change the owner name of ACLs you want to import.

Import Security Definitions dialog - Owners tab

Current Owner

A read-only list of the owners of each ACL in the Secured Input File.

New Owner

Specify a new owner name for an ACL in the Secured Input File. Use the browse button to open the Security Users dialog and select an owner (see Security Users).

Shortcut Menu Commands

Right-click to select from the following shortcut menu commands:

Copy Name
Copies the Current Owner name to the New Owner column for the ACL. Available in the Current Owner column only.
Populate
Clear
Copies the Current Owner name to the New Owner column for all ACLs.
Add
Copies the Current Owner name to the New Owner column for ACLs without a New Owner name.
Empty
Empties names from the New Owner column for all ACLs.

Objects Tab

Use the Objects tab to review or change the names of security definitions you want to import.

Import Security Definitions dialog - Objects tab

Object Type

Identifies the security definition as an ACD, ACL, or FAD. For ACLs, the following abbreviations identify the secured object types:

AD
Access Definition
ARCH
Archive Request
CALENDAR
Calendar
CM
Column Map
CMPROC
Column Map Procedure
COMP
Compare Request
CONV
Convert Request
CURRENCY
Currency Table
DBALIAS
DB Alias
DEL
Delete Request
ED
Edit Definition
EXTR
Extract Request
LOAD
Load Request
PK
Primary Key
REL
Relationship
REPT
Report Request
REST
Restore Request
STORPROF
Storage Profile
TM
Table Map
UPIN
Update or Update/Insert Request

Object Name

The names of the security definitions available for importing.

New Object Name

Specify a new name for the security definition. The name must comply with the naming conventions for the security definition.

Shortcut Menu Commands

Right-click to select from the following shortcut menu commands:

Copy Name
Copies the Object Name to the New Object Name column for the security definition. Available in the Object Name column only.
Populate
Clear
Copies the Object Name to the New Object Name column for all security definitions.
Add
Copies the Object Name to the New Object Name column for security definitions without a New Object Name.
Empty
Empties names from the New Object Name column for all security definitions.

Run Import

To import security definitions, choose the File > Run menu option.

Note: The Run command will not be available until you select at least one available security definition.

During Security Definition Import processing, the Import Progress pane displays the number of security definitions of each type that are imported and the number of errors encountered.

The status bar displays information about the current security definition that is processed. When Security Definition Import processing is finished, the status bar displays the message “Ready.”

Import Errors

If the Import Security Definitions Utility encounters errors, processing continues according to the specification for the Continue import if error(s) option. Errors are displayed on the message bar and represented visually by a red “X” beside each security definition in error. Errors are written to the Security Import Process Log after Import Processing is finished. You can review and print the Security Import Process Log for diagnostic information about errors.

If some objects fail to be imported due to errors, check the specifications, and try Export and Import again.

Import Process Log

When Security Definition Import Processing finishes, select the Tools > Show Process Log menu option to display the Security Import Process Log.

Security Import Process Log dialog
Creation Date
Date and time the Security Import Process Log was created.
List of errors
Explanatory text for each error if errors were encountered.
List of imported objects
Names of the imported security definitions, listed by object type and name.

Print

Print the log by choosing the File > Print menu option. Each execution of the Security Definition Import clears the log before information for the current execution is written. Previous log information is not retained.



Feedback