← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Request User Table in DHIS2

 

The other alternative is to use the API of course. What exactly are you
trying to achieve?


On Tue, Jul 25, 2017 at 11:28 AM, Carlos Nyembwe <nyembwe@xxxxxxxxx> wrote:

> thanks Jason,
>
> I understand you well but, I'm sorry for that because I don't have the
> local database now, I have to download it
>
>
>
> On Tue, Jul 25, 2017 at 10:22 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Hi Carlos,
>> This has been put into place as a measure to prevent the potential
>> accidental exposure of usernames and password hashes.
>>
>> You can perform the query using a direct connection to the database, but
>> DHIS2 should block any SQL views with references to some protected tables.
>>
>> Regards,
>> Jason Pickering
>>
>> On Tue, Jul 25, 2017 at 11:13 AM, Carlos Nyembwe <nyembwe@xxxxxxxxx>
>> wrote:
>>
>>> Hi all
>>>
>>> I have a problem about SQL request in DHIS2
>>>
>>>
>>> When I request the table User in front end, I see this message, but for
>>> now, I want to have some situation about User in my extence DHIS2
>>> SQL query contains references to protected tables
>>>
>>> How can help me?
>>>
>>> Regards
>>>
>>> Carlos
>>>
>>> --
>>> *Carlos Nyembwe*
>>> *I'm just a Computer Scientist*
>>>
>>> *Skype: carloscnk1*
>>> *Cell: (+243)813166381 <+243%20813%20166%20381>*
>>> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | **Linkedin
>>> <http://www.linkedin.com/in/carloscnk> | Facebook
>>> <https://www.facebook.com/carloscnksys> | Twitter
>>> <https://twitter.com/Carlos_CNK> |*
>>>
>>> _______________________________________________
>>> 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 <+46%2076%20414%2070%2049>
>>
>
>
>
> --
> *Carlos Nyembwe*
> *I'm just a Computer Scientist*
>
> *Skype: carloscnk1*
> *Cell: (+243)813166381 <+243%20813%20166%20381>*
> *Find me in: | Google Plus <https://plus.google.com/+CarlosNyembwe> | **Linkedin
> <http://www.linkedin.com/in/carloscnk> | Facebook
> <https://www.facebook.com/carloscnksys> | Twitter
> <https://twitter.com/Carlos_CNK> |*
>



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

References