← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #24386

SQL View Permissions

  Thread Previous • Date Previous • • Thread Next 
Hi all,
Is there a way I could get access to special tables in dhis2? I'm trying to create sql view with the statement "SELECT username,lastlogin FROM users order by lastlogin;" and when I try to save the sql view I'm getting the message "Not allowance to query in the special tables!" We want to monitor by name who frequently logs-in the system.
Gomez.

Follow ups

  Thread Previous • Date Previous • • Thread Next