Disabling a Workspace module in VMware Horizon Workspace 1.x

After installing Horizon Workspace you have to activate modules with a green button in the homepage of administration.

If you activate one by mistake though you have no way to deactivate it.

In KB2056300 there is a procedure which explains how to deactivate modules:

 

If a browser interface to the PostgreSQL database is available:

1. Open a browser and connect to the PostgreSQL database.
2. Connect to https://DatabaseServer:8443.
3. Log in using your credentials.
4. Expand the databases (on the left side of the screen).
5. Select saas.
6. Click Enter SQL.
7. Paste the appropriate script in the SQL Script. For a list of scripts, see below.
8. Click Execute.

If browser access to the PostgreSQL database is not available:

Log into the Appliance or virtual machine where the PostgreSQL database is installed as root.

su postgres

cd /opt/vmware/vpostgres/current/bin

./psql saas

Type in the appropriate script line from the list below and end it with a ; (semicolon)

/q

Scripts

• To disable the View module, run this query:

  update saas.”Module” set “enabled”=FALSE where “moduleName”=’View’

• To disable Web Applications module, run this query:

  update saas.”Module” set “enabled”=FALSE where “moduleName”=’SaaS’
  

• To disable the Mobile module, run this query:

  update saas.”Module” set “enabled”=FALSE where “moduleName”=’Mobile’
  

• To disable ThinApp packages module, run the following query:

  update saas.”Module” set “enabled”=FALSE where “moduleName”=’ThinApp’