Access to database rows

[jwerfel]

I have created a database through DreamFactory and I have created a simple UI that allows users to add rows to the database. Through my UI I would like to then be able to show entries the user has added. I know how to do all of this but my concern is, how do I prevent user A from viewing user B’s data? The query from the UI to filter the database results will include the logged in user ID, but anyone could easily see that raw request, change the user ID and be able to view another user ID. Is there some way on the server to restrict the rows in the database a user has access to?

Thank you

[jeffreystables]

This is easily accomplished with server-side scripting. Here is a thread that covered this topic thoroughly:

How would I manage (in the DSP), every user has his/her own Todo-List?

subject sais it all: let’s say, I want every user to have his/her own todo list, which is created when the user registers (or confirms his/her registration). How would I do this in the DSP? thx

And here is another thread with some more details:

How to give fine grained method permission to a DSP service accessing a remote REST web service

Hello everybody, I managed to set up a new DSP service that in turn accesses a remote REST web service. The DSP service is comprised of the following entities /users - Representing all users in the system /users/{user_id} - Representing a specific user in the system /users/{user_id}/reservations - Representing all reservations of a specific user in the system /users/{user_id}/reservations/{reservation_id) - Representing a specific reservations of a specific user in the system Now I was …

And here are some references from our documentation that give you a technical basis for the details:

• Common Features of Database Services
• Server-Side Filtering by Record Owner
• Server-Side Scripting
• Accessing the API from Server-Side Scripts