Re: When to create a new user?
- Date: Wed, 19 Aug 2015 10:39:16 -0700
- From: James Moe <jimoe@xxxxxxxxxxxxxx>
- Subject: Re: When to create a new user?
-----BEGIN PGP SIGNED MESSAGE-----
On 08/19/2015 10:06 AM, Richard Reina wrote:
> Data stored for each user would be a list of places visited that
> and details relating to those trips. The type of queries they would
> be able to perform be able to read, update and create new records.
I see no reason to create a unique user account for this use case.
Each user's data goes into a singe table, and a view based on the
user's ID would restrict data access for each user.
moe dot james at sohnen-moe dot com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
-----END PGP SIGNATURE-----
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql