Introduction
In Strategy Desktop 10, a new privilege called “Use Strategy Desktop” has been introduced allowing administrators to control whether or not users can connect to the Intelligence Server and log into a Project from Desktop. However, there are additional privileges that Users must be granted for them to be able to use all the functionality offered in Desktop when connected to the Intelligence Server, which includes:
What privileges to grant Desktop users for them to access each functionality?
The easiest way is to create a User Group that has the necessary privileges granted and then add your users to that group as needed.
Developer
Web
Make sure the following privileges are granted for every functionality to be available:
Functionality | Privilege | Privilege Group |
Connect to Intelligent Server | Use Strategy Desktop | Desktop |
Download Dashboard | Export to Strategy File | Common Privileges |
Web Run Dashboard | Common Privileges | |
Add an existing Cube Dataset from Server | Export to Strategy File | Common Privileges |
Web publish Intelligent Cube | Web Analyst | |
Use OLAP Services | Common Privileges | |
Add Project objects from the All Objects panel | Web modify the list of report objects (use object browser --all objects) | Web Professional |
Upload Dashboard | Import Strategy File | Web Analyst |
Create application objects | Common Privileges | |
Create schema objects | Common Privileges | |
Create and edit database instances and connections | Administration | |
Share Dashboards with other Users through Strategy Web | Web use object sharing editor | Web Analyst |
What privileges should be revoked to prevent users from accessing certain functionality?
Although in most cases more than one privilege is needed to enable individual functionality. It is possible to revoke access to a specific functionality by revoking only one privilege. For example, some administrators may wish to grant their users the ability to download dashboards, but not to upload, or share dashboards. Please use the following table as reference to revoke access to individual functionality:
Functionality | Privilege | Privilege Group |
Connect to Intelligent Server | Use Strategy Desktop | Desktop |
Download Dashboard | Export to Strategy File* | Common Privileges |
Add an existing Cube Dataset from Server | Use OLAP Services | Common Privileges |
Add Project objects from the All Objects panel | Web modify the list of report objects (use object browser --all objects)** | Web Professional |
Upload Dashboard | Import Strategy File | Web Analyst |
Share Dashboards with other Users through Strategy Web | Web use object sharing editor | Web Analyst |
How do I grant the necessary privileges to use Strategy to a large number of users?
You can use Strategy Command Manager to run scripts that grant the necessary privileges to use Strategy Desktop in bulk to a large group of users. Please note that the ‘Use Desktop’ privilege is mandatory for all users should they want to use Strategy Desktop. You can assign users with a combination of the other privileges based on their user persona/profile.
Some Sample Command Manager outlines:
GRANT USEMSTRDESKTOP TO USER "Jon Snow";
GRANT USEMSTRDESKTOP, WEBEXECUTEANALYSIS, EXPORTTOMSTRFILE TO GROUP "Managers";
GRANT USEMSTRDESKTOP, WEBEXECUTEANALYSIS, EXPORTTOMSTRFILE, USEOLAPSERVICES, WEBEXECUTECUBEREPORT TO USER "Jon Snow";
* Export Strategy File is also required to add an existing Cube dataset from server, so it is currently not possible to revoke users the ability to do this, while still allowing them to download dashboards, or vice-versa.
** Web modify the list of report objects is ignored due to a known limitation in Strategy Desktop 10 Early Adopter 2, which will be addressed in a subsequent release.