Mis 561 Ilab 3: Users, Privileges, and Roles

MIS 561 iLab 3: Users, Privileges, and Roles

Copy and Pate below link into your Browser to buy tutorial
http://hwpool.com/product/mis-561-ilab-3-users-privileges-and-roles/

MIS 561 iLab 3: Users, Privileges, and Roles

iLab 3: Users, Privileges, and Roles (60 pts.)
iLAB OVERVIEW
Scenario and Summary
MySQL, like many other databases, uses the combination of specific user definitions, privileges, and roles to control access to the data in the database. In turn, it provides various layers of security. When the database is first created, there are several users created for the purpose of not only installing various components of the database, but also to manage and administer the database functionality. You have already used administrative role users in previous labs. In this lab, you will be creating a series of different users, administering various privileges to those users, and exploring how roles help provide additional functionality to the user picture.
It could be achieved in two ways:
• Using command line to access MySQL directly;
• Using MySQL Workbench User and Privileges option.

Very important!Be sure to save all screenshots on Terminal and MySQL Workbench while executing your SQL code when working on the lab.
Deliverables
Grading of the lab assignment will be based on the following.

Part 1: Using Command Line on Terminal
1. Add two new users. Grant super user access to one and read-only access to all tables in the database to the second user (Step 1, Step 2, and Step 3).
To prove the super-user access for User 1, please write query to SELECT, DELETE, INSERT, UPDATE from any created table and show successful results.
To prove the read-only access for User 2, please write query to SELECT, DELETE, INSERT, UPDATE from any created table. SELECT, DELETE, INSERT, UPDATE from any created table (Note: Only SELECT query will be eligible.)
Sample of commands to check access:
Mysql>show databases;   – will list database names;
Mysql>use...