Absent Member.
Absent Member.
119 views

User rights to launch queries

Hi all:

Im my organization, we are using a "customized Dashboard" based in excel macros since the HPQC Dashboard tool has some performance problem.
Well, I know that, in order to launch queries against the database, users need to have administration rights but, somebody knows if there is a particular checkbox in the Administration area (view attachment) the checking of wich grants the availability of launching queries ?

Thanks in advance,
0 Likes
4 Replies
Fleet Admiral
Fleet Admiral

How did you create the Excel marcro? Do you access the data by SQL or does your macro use the OTA API?
0 Likes
Absent Member.
Absent Member.

Errr... I think that we use both. But in any case: How would it condition the answer ?

Cheers,
0 Likes
Absent Member.
Absent Member.

Nothing in Project group Admin area for OTA access
Some SQL restriction parameters for Site Admin
Group data hiding ect could apply in QC10 - havnt tried
0 Likes
Absent Member.
Absent Member.

You need to do it in the "Analysis" tab. If you want the user to be able to just execute queries but not create new ones, then just check "Generate excel reports". If you want to allow him/her to write queries, check "Design excel reports" as well.

Refer attachment for screenshot
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.