User Licenses

The User Licenses is a table (md_user_license) in the User Management System (UMS). This table defines the databases that the user can access. Licenses also define the rights each user has to the databases.

The license types full and read_only are exclusive. The system will prevent assigning both license types to a user.

Note: You cannot modify information on the view. You must delete the record and then create a new record with the correct database/license information.

The following list defines every field available in the user licenses (md_user_license) table in alphabetical order:

• Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

• Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

• Database Name - the database associated with the user. The following database options are valid with PointForce iTopia:
  • iBIS (the iTopia database)
  • meta

• License Type Name - the license types are associated with the databases for each user. The following license types are available:
  • Full - unlimited access to a particular view, subject to the security imposed by the system administrator at the role/user level.

  • Read Only - limited access to Enterprise views. This license type is assigned to users that only need to make enquires into the Enterprise data (i.e. users with read-only access cannot create update or delete records in any view).

  • Web Services - allows the user to access a given module only through Web Services, for example a third-party application.

  • External Analysis – allows the user the ability to run features enabling data analysis using external resources. This option allows users to use the Analyze with Excel feature.

  • External Editing – allows the user the ability to run features enabling data editing using external resources. This option allows users to use the Edit with Excel feature.

  Note: The license types Full and Read Only are exclusive. The system will prevent assigning both license types to a user.

• User Name - the user's name.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.