Users, Privileges, and Roles

Affordable Essays
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:
1) Using command line to access MySQL directly;
2) 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
a) 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 database name; – Access allowed or denied.
Add screenshots to Report.
b) Modify access of the second user by adding update access to Employee table (Step 4). Add screenshots to Report.
To prove the UPDATE privilege, please log in again as User 2 and update COMM column in Employee table.
MYSQL> UPDATE Employee SET COMM = 0.1;
Add screenshots to Report.
Assignment Step
Description
Computer Science homework help
With unimasteressays.com’s essay writing service, you can always rest easy knowing that when you say “write my essay”, you will get a superior quality plagiarism-free, professionally written paper. Just proceed and place an ORDER NOW.

Do You Need A Similar Assignment?

Place an order with us. Our skilled and experienced writers will deliver a custom paper which is not plagiarized within the deadline which you will specify.

Note; 6 Hours urgent orders deliver also available.

If you need more clarifications contact our support staff via the live chat for immediate response.

 

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: