IT 234 IT234 IT/234 Unit9Assignment_Lofton

$3.99

IT 234 IT234 IT/234 Unit9Assignment_Lofton

Unit 9 Assignment Kaplan University IT234 Database Concepts James Lofton

Unit 9 Assignment

9-1 Create four new roles in the Northwind database:

SalesPerson

SalesManager

HRperson

HR Manager

Description

IT 234 IT234 IT/234 Unit9Assignment_Lofton

Unit 9 Assignment Kaplan University IT234 Database Concepts James Lofton

Unit 9 Assignment

9-1 Create four new roles in the Northwind database:

SalesPerson

SalesManager

HRperson

HR Manager

9-2 Use Data Control Language (DCL) statements that manage database user permissions.

Grant permissions for Sales Related tables to SalesPerson role to select, insert, and update.

Grant permissions for SalesManager to also delete on the Sales Related Tables.

Grant permissions for select, insert, and update for HR Related tables to HRperson role.

Grant permissions to the HRManager to also delete on HR Related tables.

9-3 Create two new users named Joe and Jane.

Give Jane the role of SalesPerson.

Give Joan the role of SalesManager

Give Joe the role of HRPerson.

Give James the role of HRManager

Once you enter the query with the commands to create the roles, grants, and users, you will simply see the following if the commands execute successfully:

IT 234 IT234 IT/234 Unit9Assignment_Lofton

IT 234 Database Foundations School: Kaplan University *Professor:JENNINGS, MichaelFenick, JasonJohnson, S… Documents (488) Q&A (1) Textbook Exercises Database Foundations Documents All (488) Assignments (3) Essays (25) Homework Help (264) Lab Reports (11) Notes (15) Test Prep (9) Showing 1 to 30 of 488 Sort by: Most Popular 5 pages

IT234_BrandonHart_Unit 7 assignment.docxIT234_BrandonHart_Unit 7 assignment.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_BrandonHart_Unit 7 assignment.docx 6 pagesIT234_ErlinCedeno_Unit8IT234_ErlinCedeno_Unit8 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_ErlinCedeno_Unit8 5 pagesIT234_Catlin_Unit 9_assignmentIT234_Catlin_Unit 9_assignment Kaplan University Database Foundations

IT 234 – Fall 2015 Register Now IT234_Catlin_Unit 9_assignment 7 pagesIT234_NWayne_Unit_8_AssignmentIT234_NWayne_Unit_8_Assignment Kaplan University Database Foundations

IT 234 – Summer 2015 Register Now IT234_NWayne_Unit_8_Assignment 5 pagesIT234_Unit8Assignment_Lofton.docxIT234_Unit8Assignment_Lofton.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 IT234 IT/234 Unit9Assignment_Lofton

IT 234 – Spring 2019 Register Now IT234_Unit8Assignment_Lofton.docx 6 pagesIT234_BrandonHart_Unit6.docxIT234_BrandonHart_Unit6.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_BrandonHart_Unit6.docx 1 pagesIT234 Roberts unit 3 assignmentIT234 Roberts unit 3 assignment Kaplan University Database Foundations

IT 234 – Winter 2014 Register Now IT234 Roberts unit 3 assignment 5 pagesIT234_Unit2Assignment_Lofton.docxIT234_Unit2Assignment_Lofton.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_Unit2Assignment_Lofton.docx 1 pagesIT234_NWayne_Unit_3_AssignmentIT234_NWayne_Unit_3_Assignment Kaplan University Database Foundations

IT 234 – Summer 2015 Register Now IT234_NWayne_Unit_3_Assignment 4 pagesUNIT 1UNIT 1 Kaplan University Database Foundations

IT 234 – Winter 2014 Register Now UNIT 1 3 pagesIT234_Strobridge_Unit2IT234_Strobridge_Unit2 Kaplan University Database Foundations

IT 234 – Winter 2014 Register Now IT234_Strobridge_Unit2 2 pagesIT234_Brandon_Unit1.docxIT234_Brandon_Unit1.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 IT234 IT/234 Unit9Assignment_Lofton

IT 234 – Spring 2019 Register Now IT234_Brandon_Unit1.docx 8 pagesIT234_Unit9Assignment_Lofton.docxIT234_Unit9Assignment_Lofton.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_Unit9Assignment_Lofton.docx 1 pagesIT234 Zina Demler Assignment 3IT234 Zina Demler Assignment 3 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Winter 2014 Register Now IT234 Zina Demler Assignment 3 9 pagesIT234_ErlinCedeno_Unit7IT234_ErlinCedeno_Unit7 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_ErlinCedeno_Unit7 2 pagesM1_Rubric.docxM1_Rubric.docx Kaplan University Database Foundations

IT 234 – Fall 2019 Register Now M1_Rubric.docx 2 pagesIT234 Denise Figueroa Unit 7 Part 2 SSMS Screen Shots .docx.lnkIT234 Denise Figueroa Unit 7 Part 2 SSMS Screen Shots .docx.lnk Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234 Denise Figueroa Unit 7 Part 2 SSMS Screen Shots .docx.lnk 2 pagesIT234_DashawnMckenzie_unit2IT234_DashawnMckenzie_unit2 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 IT234 IT/234 Unit9Assignment_Lofton

IT 234 – Spring 2019 Register Now IT234_DashawnMckenzie_unit2 3 pagesIT234 Denise Figueroa Unit 9 AssignmentIT234 Denise Figueroa Unit 9 Assignment Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234 Denise Figueroa Unit 9 Assignment 3 pagesIT234 Denise Figueroa Unit 8 AssignmentIT234 Denise Figueroa Unit 8 Assignment Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234 Denise Figueroa Unit 8 Assignment 3 pagesUnit 9 SeminarUnit 9 Seminar Kaplan University Database Foundations

IT 234 – Winter 2014 Register Now Unit 9 Seminar 5 pagesIT234_NWayne_Unit_5_AssignmentIT234_NWayne_Unit_5_Assignment Kaplan University Database Foundations

IT 234 – Summer 2015 Register Now IT234_NWayne_Unit_5_Assignment 5 pagesIT234 JewelStott_Unit_9_Assignment 2IT234 JewelStott_Unit_9_Assignment 2 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 IT234 IT/234 Unit9Assignment_Lofton

IT 234 – Spring 2014 Register Now IT234 JewelStott_Unit_9_Assignment 2 3 pagesCalebReilly_M1_Assessment.docxCalebReilly_M1_Assessment.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Winter 2014 Register Now CalebReilly_M1_Assessment.docx 5 pagesIT234_Unit7Assignment_Lofton.docxIT234_Unit7Assignment_Lofton.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_Unit7Assignment_Lofton.docx 15 pagesIT234_ErlinCedeno_Unit6IT234_ErlinCedeno_Unit6 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Spring 2019 Register Now IT234_ErlinCedeno_Unit6 1 pagesIT234_Burgoyne_Unit 6 Discussion Topic 1 (6).docxIT234_Burgoyne_Unit 6 Discussion Topic 1 (6).docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Winter 2014 Register Now IT234_Burgoyne_Unit 6 Discussion Topic 1 (6).docx 5 pagesIT234_Strobridge_Unit7IT234_Strobridge_Unit7 Kaplan University Database Foundations

IT 234 – Winter 2014 Register Now IT234_Strobridge_Unit7 5 pagesIT234_AshleyQuigley_UNit2IT234_AshleyQuigley_UNit2 Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 IT234 IT/234 Unit9Assignment_Lofton

IT 234 – Winter 2014 Register Now IT234_AshleyQuigley_UNit2 5 pagesIT234_TinaKingston_Unit8IT234_TinaKingston_Unit8 Kaplan University Database Foundations

IT 234 – Winter 2014 Register Now IT234_TinaKingston_Unit8 Prev 1 2 3 4 5 Next Recent Documents 2 pagesIT234_JazmineBrown_Unit1.docxIT234_JazmineBrown_Unit1.docx Kaplan University DATABASE MANAGEMENT SYSTEMS

IT 234 – Fall 2019 Register Now IT234_JazmineBrown_Unit1.docx Database Foundations Tests Questions & Answers Showing 1 to 1 of 1 View all Using the AdventureWorks 2012, Northwind, NWTraders, Alexamara, or Pubs databases that you installed earlier, formulate two original subqueries, one of which 1 2 3 4 5

Back to Department Related Courses IT 190 – network concept (611 Documents)IT 301 – Project Management I (572 Documents)IT 273 – Networking Concepts (509 Documents)IT 331 – Information infrastructure (443 Documents)IT 133 – Software Applications (415 Documents)

IT 286 – Network Security (368 Documents)IT 222 – IT (356 Documents)IT 213 – Intro to Software Developement Concepts (338 Documents)IT 332 – Principles of Information Systems Architecture (317 Documents)IT 104 – Intro to Cybersecurity (297 Documents)