← Back to team overview

dhis2-users team mailing list archive

SQL View Permissions

 

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