Database Security

Assignment: Comparing Table-Level and Column-Level Privileges in Database Security
Instructions
Assignment Directions:
For this Assignment, you will write a paper that focuses on analyzing the advantages and disadvantages of managing database privileges at the table level versus the column level.
• Explore how each approach impacts data security, control, and flexibility in managing access for different types of users.
• Evaluate real-world scenarios where both methods might be employed and discuss the importance of aligning privilege management with the principle of least privilege.
• Your paper should provide insights into how these privilege levels contribute to maintaining data confidentiality, integrity, and availability across different database platforms.
Submission Instructions:
• A Word document of 8-10 pages (double-spaced), Times New Roman, 12 pt. font.
• The paper must have an abstract, table of contents, introduction, conclusion, and section headings.
• Use at least five (5) references outside of your textbook (you may use your textbook as well but are not required to).
• In addition to the required number of pages for the assignment, you must also include a reference page (bibliography) written in APA style and a title page. Be sure to give all of your papers a descriptive title!
• Typewritten in double-spaced format with a readable style and font and submitted inside the electronic classroom (unless classroom access is not possible and the professor has approved other arrangements).
• Page margins: top, bottom, left side, and right side = 1 inch, with reasonable accommodation being made for special situations.
• Your paper must be in your own words, representing original work. Paraphrases of others’ work must include attributions to the authors. Limit quotations to an average of no more than three to five lines, and use quotations sparingly! It is always better to paraphrase than to quote directly.
Be sure to review the following prior to submitting your assignment:
• Academic Integrity Guidelines [content page]
• Assignment Rubric
o If you do not see the rubric, in the blue horizontal navigation bar select Course Tools, then Assignments. Select the appropriate assignment, and the rubric will be located near the bottom of the page.
This Assignment aligns with the following:
• Course Objective 4 [content page]
o Lesson Objective 4.6 [content page]
Resources & Supports
• Office 365 [webpage]: You have free access as an APUS student. Sign in with your MyCampus Email credentials.
• Submitting and Confirming a Submission : Watch this 3-minute video if you need guidance on submitting your assignment.