I have a specific dataset that I want a client to have access to, but only in a manner that they cannot see/query the data, but can reference table and fields for their calculations. A well documented user guide will be provided. Is this technically possible? If so, how can I go about doing this.
Asked
Active
Viewed 27 times
0
-
"*reference table and fields for their calculations*" - Waht does it mean? – PM 77-1 Mar 06 '17 at 20:31
-
For example: in a table called price, I have fields called product name, retail price, wholesale price. I don't want the customer to be able to see the data in these fields. However the customers tech department should be able to join a product name to the product to name in my table and get a price for wholesale or retail based on the data contained in my tables. They cannot however query the tables I have and the data will reside on my server. – Noobajaxpython Mar 06 '17 at 22:33
-
You may want to hide that database completely and instead expose services for your customers in whatever limited scope you need. – PM 77-1 Mar 06 '17 at 23:01
-
Thank you PM 77. I am happy to research it more, however I didn't know the exact technical term for hiding the database and exposing services in my limited scope. Am I correct in understanding that I'd need to go through hiding a db and exposing services? – Noobajaxpython Mar 07 '17 at 03:54
-
Have a look at http://stackoverflow.com/questions/2142070/why-should-a-developer-use-web-services-instead-of-direct-connections-to-a-db – PM 77-1 Mar 07 '17 at 15:26