Upload Tool Permission for Shared User

Upload Tool Permission for Shared User

 Hi. I'm trying to upload csv files with the upload tool console using the credentials of a user that is not the owner of the database, but has all permissions for read, write and import. But I get this error:

   
    
    
  1. Error!!! Database not found! Please check whether the database exists Exception in thread "main" ServerException (HttpStatusCode 400 Error Code: 7103 , URI: /api/hotlobatest/GasAca/Diario, Action: IMPORT, Message: Database not found! Please check whether the database exists) at com.adventnet.zoho.client.report.BaseClient.sendRequest(BaseClient.java:102) at com.adventnet.zoho.client.report.ReportClient.sendImportRequest(ReportClient.java:712) at com.adventnet.zoho.client.report.ReportClient.importTblData(ReportClient.java:701) at com.adventnet.zoho.client.report.ReportClient.importData(ReportClient.java:659) at com.adventnet.zoho.client.report.ReportClient.importDataInBatches(ReportClient.java:613) at com.adventnet.zoho.client.report.tool.CSVUploader.upload(CSVUploader.java:127) at com.adventnet.zoho.client.report.tool.CSVUploader.upload(CSVUploader.java:67) at com.adventnet.zoho.client.report.tool.CSVUploader.main(CSVUploader.java:47)
    2.


It works fine when I use the database owner's credentials.

Does this means that a shared user can't import using the upload tool? I think that for security reasons it's very important to allow this. Otherwise anybody with access to the computer could access the owner's credentials, since you have to include them in cleartext in the call to CSVUploadConsole.bat.

By using a shared user with only import privileges you could protect the database and all the reports from unauthorized users. Very important if you want to work with sensitive data.