Mapping users to all of their files(URLs) in a mysql database.
2 tables: user and user_uri_permission? 2 columns in the second: userID and URI. When the User-URI pair is in the table the use has access.
What I want is that when I have looked up a user in a table, I want to list all the file urls that the user have access to. My first thought was to have a field in the table with a list of file URLs. However, I have now understood that there are no such field type. 
I was then thinking that maybe ForeignKeys might work, but I am having trouble getting my head around it. 
Another solution maybe is to have one table for each user, with each row representing each file.
What would you say is best practice in this case? 
I am also going to expand into having shared files, but thought that I'd address this issue first.