Question
Mathieu Van Sevenant · Jan 22, 2021

How to grant access to the Event Log ?

Hello everyone :-)

I would like to grant access to the Event Log (below in French "Journal des événements") to a user, and more generally to an existing group of users (this group is named "Helpdesk").

Helpdesk has already access to the following tables:

 

...But still the Event Log remains inaccessible:

I see that the error message is about "SQL privileges" and indeed the Helpdesk group has no one for now. But it does not look familiar to me. Here is below those privileges that some other user (which has access to the Event Log) has got:

Should I add some of them into the Helpdesk group ?

(And yes in any case, the user who got the error is part of the group Helpdesk: )

 

Could you please help me ?

Best regards,

Mathieu

$ZV: Cache for Windows (x86-64) 2018.1.4 (Build 505_1U) Thu May 28 2020 10:01:40 EDT
Product version:
HealthShare 2018.1
00
1 0 4 65

Replies

To add to Vic's response I suspect that the access violation is not necessarily about the sql access rights to the event tables but rather the access rights to the UI component that displays the event log and the access rights to access the database using SQL. I suspect that you need to assign an appropriate role(s) that will give the user access to the UI component and the ability to run sql. You can test this last aspect by using the Management Portal - System Explorer -> SQL and attempt to execute a simple query "select * from {table}" where {table} is the event table you want to access. I don't have access to HS 2018.1 at the time of writing this response.

Th answer of course will lie in the documentation as suggested by Vic. The trick is to ensure that the user has enough priviledge to do what they need to do but do not have so much access that they could potentially get to areas of the Management Portal and data that they should not have access too. It can be a bit tricky to get it perfect. If you have many users who need this specific access and it turns out that you require a combination of certain roles, tables etc then create a generic user with those assigned attributes and then when creating new users use the "Copy From" option on the "Create New User" page and specify the generic user you have created.

Nigel

Add SELECT for Ens_Util.Log table to view events.

Thank you Vic, Nigel and Eduard !

It seems that adding "Ens_Util.Log", as suggested, was useful.

Best regards,

Mathieu