Promote a user to administrator (Local only)

If your IBM® Planning Analytics Workspace administrator is no longer available, you can promote a non-admin user to the administrator role by using the command line. If you're upgrading to Planning Analytics Workspace 2.0.92 or a higher version, you can also use the command line to assign Environments admin privileges to a user.

This approach is the only way to promote a user to the administrator role without logging in to Planning Analytics Workspace with an existing administrator role account. This is also the only way to provide the Environments administration privilege if there is no administrator role user with that privilege.
Note: If you are using Planning Analytics Workspace Distributed, replace all instances of wa-proxy in the following commands with the containerID. You can find the containerID by using the docker ps command.
  1. Run the following command to see a list of users in this environment and their most recent logon. While this command returns some of the same information as the command in Step 2, it includes most recent logon, which might be useful in identifying the user that you want to promote to administrator.
    • On Windows:
      docker exec -it wa-proxy powershell -command "C:\wa-proxy\tools\runTool.ps1" findLoggedInAtleastOnceUsers
    • On Red Hat Enterprise Linux® 7:
      docker exec -it wa-proxy bash -C /wa-proxy/tools/runTool.sh findLoggedInAtleastOnceUsers
    • On Red Hat Enterprise Linux® 8 and 9:
      sudo podman exec -it wa-proxy bash -C /wa-proxy/tools/runTool.sh findLoggedInAtleastOnceUsers
  2. Run the following command to see a list of users in this environment, including their login ID, display name, user ID, and role.
    • On Windows:
      docker exec -it wa-proxy powershell -command "C:\wa-proxy\tools\runTool.ps1" changeUserRoleToAdmin
    • On Red Hat Enterprise Linux® 7:
      docker exec -it wa-proxy bash -C /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
    • On Red Hat Enterprise Linux® 8 and 9:
      sudo podman exec -it wa-proxy bash -C /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
  3. Identify the user ID for the user that you want to promote to the administrator role and run the following command with the appropriate userID:
    • On Windows:
      docker exec -it wa-proxy powershell -command  "C:\wa-proxy\tools\runTool.ps1" changeUserRoleToAdmin <userId>
    • On Red Hat Enterprise Linux® 7:
      docker exec -it wa-proxy bash -C  /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
      <userId>
    • On Red Hat Enterprise Linux® 8 and 9:
      sudo podman exec -it wa-proxy bash -C  /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
      <userId>

Assigning Environments privileges to a user (Local only)

If you are upgrading to Planning Analytics Workspace 2.0.92 and want to create and manage multiple environments in Planning Analytics Administration Local, you must assign Environments admin privileges to at least one user with the administrator role.

Note: If you are a new Planning Analytics Workspace user, installing 2.0.90 or a higher version for the first time, the first user with the administrator role automatically gets Environments admin privileges.
You can promote a non-admin user to an administrator role and assign Environments admin privileges to them in one go with the following command:
  • On Windows:
    docker exec -it wa-proxy powershell -command  "C:\wa-proxy\tools\runTool.ps1" changeUserRoleToAdmin <userId>
  • On Red Hat Enterprise Linux® 7:
    docker exec -it wa-proxy bash -C  /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
      <userId>
  • On Red Hat Enterprise Linux® 8 and 9:
    sudo podman exec -it wa-proxy bash -C  /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
      <userId>
To assign an existing administrator with Environments admin privileges, run the following command:
  • On Windows:
    docker exec -it wa-proxy powershell -command  "C:\wa-proxy\tools\runTool.ps1" changeUserRoleToAdmin <userId>
  • On Red Hat Enterprise Linux® 7:
    docker exec -it wa-proxy bash -C  /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
      <userId>
  • On Red Hat Enterprise Linux® 8 and 9:
    sudo podman exec -it wa-proxy bash -C  /wa-proxy/tools/runTool.sh changeUserRoleToAdmin
      <userId>

If you want to remove a user from Environments admin privileges, run the command to see a list of users in the environment and set their environments_admin_privileges property to false.