Users and roles

User access is controlled by user type and user role. Administrative users have full access across Analytics Exchange while non-administrative users have application-level permissions that control collection and folder-level access.

User types

There are two types of AX Server users:

User roles

With the exception of the Super Admin, every user in AX Server is assigned one or more of the following roles:

For more information about each role in AX Server, see User security.

Web Client Access licensing

Depending on your organization’s AX Server license, one of four scenarios is possible when granting access to AX Web Client:

If your license does not include AX Web Client access, or if all licenses are in use, you cannot assign the Web Client Access role to users.

Audit item permissions

Users with Core Client Access and Web Client Access roles have further application-level permissions that control which Working directory or Library audit item they can work with.

Each collection and folder has individual permissions that specify:

Note:

Users with the Admin role have “Full permissions” to all audit items.

For more information about audit item permissions, see .

Permission and role change log in AX Server

AX Server tracks all permission and role changes in the userpermissionlog table of the database.

Using this table, you can query information about the following actions:

userpermissionchangelog table

Column Data Type Nullable Description
logId
  • bigserial (Oracle)
  • biserial (PostgreSQL)
N The auto-incrementing primary key for the record.
Note

If records with the same transactionid value do not have sequential logId values, check your database logs to ensure a manual deletion was not executed on the table.

transactionid
  • NVARCHAR2(40) (Oracle)
  • text (PostgreSQL)
N The unique identifier of the user action that creates the record.
Tip:

A single action in the user interface can create multiple records in this table. Group records by the transactionid to find all permissions changes associated with a single user action.

userid
  • NVARCHAR2(100) (Oracle)
  • text (PostgreSQL)
N The user ID of the user whose role or permission changes as a result of the action.
username
  • NVARCHAR2(2000) (Oracle)
  • text (PostgreSQL)
N The username of the user whose role or permission changes as a result of the action.
audititemid
  • NVARCHAR2(40) (Oracle)
  • uuid (PostgreSQL)
Y The identifier of the audit item that the user’s permission change affects. Null on role change.
permissiontype
  • NVARCHAR2(2000) (Oracle)
  • text (PostgreSQL)
Y The users permission type for the record.
action
  • NVARCHAR2(2000) (Oracle)
  • text (PostgreSQL)
N The action taken by the user who makes the change.
changebyuserid
  • NVARCHAR2(100) (Oracle)
  • text (PostgreSQL)
Y The user ID of the user that made the permissions change.
changedbyusername
  • NVARCHAR2(2000) (Oracle)
  • text (PostgreSQL)
N The username of the user that made the permissions change.
changetime
  • timestamp (Oracle)
  • timestamp (PostgreSQL)
N The timestamp for the record change.
application
  • NVARCHAR2(32) (Oracle)
  • text (PostgreSQL)
N The application from which the change was made:
  • ACLConfig: AX Server Configuration
  • RestV1: AX Rest API
  • AXClient: AX Client
  • N/A: collection restore job