← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] DHIS2 users list from SQL View

 

Hi there.

Due to the sensitivity of this table (and others) it is not available as an
SQL view. The reason is because that query would expose users password
hashes, which of course would not be great from a security perspective.

I would suggest you use the API with something like

https://play.dhis2.org/dev/api/users?fields=displayName,userCredentials[code]&paging=false

Regards,
Jason


On Mon, Apr 10, 2017 at 4:19 PM, Raminosoa Rabemanantsoa, Tantely <
traminosoa@xxxxxxxxxx> wrote:

> Dear Community,
>
> I would like to output from SQL View a list of all DHIS2 users by using
> headers like the information listed by the users details information, like
> illustrated by the image below (inside red ellipse).
>
>
> ​
>
> I am using DHIS2 2.24. I would like to check the users table fields but I
> could not output any information from the following query
>
> select * from users;
>
> as trhere are some protected info.
>
> My question is in which fields should I base the SQL query to output such
> information?
>
> Thank you for your support,
>
> Regards,
>
> Tantely
> ​
>
>
>
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

JPEG image


References