File System Groups File Maintenance provides an option for Identities at the bottom of the screen (as does Users File Maintenance which is addressed in the Security section of System Administration). Identity records are maintained by FMS Group/User combination. They provide the place to store login information by FMS Group for each APPX user who requires it, giving the system administrator more flexibility in controlling access.
A “unique” identity is tied to the three character APPX User ID. When the user attempts to connect to an external RDBMS, APPX tries to find an identity record that corresponds to the User ID. If it finds one, the User ID and password designated in the record is passed to the RDBMS. If APPX is unable to find a unique identity record for the User ID, it looks for a “default” identity record.
A “default” identity record for the FMS Group can be set up by creating one with a blank APPX User ID. The User ID and password from this “default” identity is then passed to the RDBMS to gain access. If neither a unique identity nor a default identity exists, then the user’s O/S Login ID and Auxiliary Password (defined in Users File Maintenance) is used. If no User ID and password is found in any of these three areas, the user is unable to access the RDMBS.
The default identity should be used in cases where the user has standard access privileges within the external RDBMS. Unique identities can then be defined for users with more—or fewer—privileges than the “standard” user.
When accessing data in an FMS Group where login information is required (such as Oracle, Sybase or APPX/NET) the login information will be searched as follows:
1. Identity record for FMS Group/User (User ID is present)
2. Default Identity record for the FMS Group (User ID is blank)
3. User’s “O/S Login ID” and “Auxiliary Password”
Note: The use of the user level O/S Login ID and auxiliary password is provided for backward compatibility and may be removed in a future release.