2015-09-21 12:51 GMT+03:00 Dancer New <[email protected]>:

> I want to make sure each user only see their own data.
....
> If I don't use one database connection for each user, how can I make sure
> the database handler know which user it is dealing with?

I assume, that in your database all records have a field for the
owner? Then you can build up your queries so that data is filtered
appropriately. Like "SELECT * FROM table WHERE owner = 'john'".

Or if everyone have their own table or even schema, you can build your
queries up counting on username. It is easier to deal with it on
application level, mostly.

Wbr,
-- 
Kõike hääd,

Gunnar
_______________________________________________
dancer-users mailing list
[email protected]
http://lists.preshweb.co.uk/mailman/listinfo/dancer-users

Reply via email to