TPS 17

Think

Insert a new row just below the header in the table in your TPS Google Doc. Fill in the first two columns. Add your response to the problem below in the "Think"column.

Suppose I have a web app that allows a user to share documents with other users (think Google Docs). The owner of a document can share it with others and give them different access levels: view or edit. Any user who is not given the level of access required for a given action is denied access.

For example, an owner may give userA view access, userB and userC edit access. If userA tries to edit the document, or if any user other than userA, userB, or userC tries to view the document, they are denied access.

Assuming we are using a relational data model to keep track of the user and document metadata, should these permissions be stored in the Documents, Users, or some other table? Explain.

Here's what the Users and Documents table might look like absent any permission information:

Users
- id
- username
- password

Documents
- id
- owner
- contents

Pair

If you are joining the class live (in person or over Zoom), pair up with someone when asked to do so—please use Discord or your preferred means of interacting with someone to share your answers (please see the announcement with details about Discord).  Settle on an answer between to two or three of you and put that answer down in your "Pair" column.

Share

Regardless of whether or not you are attending live, one person from your pair group should add your answer to the "TPS class share Links to an external site." document (make sure you're logged into your Endicott gmail account).

Submit

Finally, submit your personal TPS Google doc to this assignment.