For Online Class Help or Private Tutoring Service email us at [email protected] or WhatsApp us at +1 (781) 656-7669

Homework Provider

 
  • Take My Class
  • Take My Exam
  • How It Works
  • Solutions
    • Questions
  • Testimonials
  • Blog
  • Who Are We
  • Contact Us
  • Take My Class
  • Take My Exam
  • How It Works
  • Solutions
    • Questions
  • Testimonials
  • Blog
  • Who Are We
  • Contact Us
  1. Home
  2. Questions
  3. DeVry MIS 561 iLab 3 Users Privileges and Roles

Contents

  • 1 DeVry MIS 561 iLab 3 Users Privileges and Roles
    • 1.1 Deliverables
  • 2 STATUS
    • 2.1 iLAB STEPS
    • 2.2 Part 1: Using command line on Terminal
  • 3 STATUS

DeVry MIS 561 iLab 3 Users Privileges and Roles

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 the 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

The grading of the lab assignment will be based on the following.

Part 1: Using Command-Line on Terminal

a) Add two new users. Grant superuser 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 a 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 a 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 to the second user by adding update access to the Employee table (Step 4). Add screenshots to Report.
To prove the UPDATE privilege, please log in again as User 2 and update the COMM column in the Employee table.
MYSQL> UPDATE Employee SET COMM = 0.1;
Add screenshots to Report.

take-my-online-class-thumbnail
Play Video
pay-someone-to-take-my-online-class

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

STATUS

 

Assignment Step Description Points

Step 1 Creating a new user using the command line on Terminal 6
Step 2 Finding information on users 6
Step 3 Finding user privileges 6
Step 4 Changing user specifications 6

Part 2: Using MySQL Workbench

Assignment Step Description Points

Step 1 Creating a new user using MySQL Workbench 6
Step 2 Finding information on users 6
Step 3 Finding user privileges 6
Step 4 Changing user specifications. Assigning users to a role 6
Step 5 Listing privileges associated with a role 6
Step 6 Verifying role content 6

Your lab session, showing any queries, create statements, or other SQL code, and the resulting return from the database–should be placed in a single file called yourname_Lab_3.txt to submit to the Dropbox for the Week 3 iLab.
Note!
This is a difficult assignment to grade, so please combine multiple outputs in a single document in the order of execution. The addition of headings for each step helps clarity. Also, please trim out any errors and unnecessary content.

iLAB STEPS

Part 1: Using command line on Terminal

STEP 1: Creating a new user using command line on Terminal

To start, launch Start, choose MySQL 5.6 Command Line Client – Unicode
Enter password: Enter your password, which you’ve created during installation; Press Enter;
We’ll check the existing users by:
Mysql> select Host, User from mysql.user;
Your response will look like this:
HOST USER
—————— ———————–
127.0.0.1 root
Localhost student1
Now, to add a new user:
Mysql> CREATE USER ‘username’@’ localhost’ IDENTIFIED BY ‘password’;
Press Enter.
Please note: Username and password are in a single quote. A statement is ended with semicolon.
Please add before and after screenshots to the Report.

STEP 2: Finding information on users

To verify currently defined users, write and execute the query to display the following information:
Mysql> select Host, User from MySQL.user;
And the result set will include a newly created user.
HOST USER
—————— —————
127.0.0.1 root
Localhost student1
Localhost student2
Please add Before and After screenshots to the Report.

STEP 3: Finding User Privileges

Creating a user doesn’t give any access to databases.
We have to grant privileges to the user.
For example, the command below grants ‘superuser’ privileges:
Mysql> GRANT ALL on *.* TO ‘user name’@‘localhost’ WITH GRANT OPTION;
Press Enter.
Where ALL – all privileges;
*.* – to all databases, all tables;
Mysql>flush privileges;
Press Enter.
Mysql>quit
To remove user:
Mysql>DROP USER ‘user name’@’localhost’; Press Enter.
To show all users and their privileges:
Mysql>select * from MySQL user;
Press Enter.
To show privileges:
Mysql>show grants for ‘username’@’ localhost’;
The result set will include grants for the user and encrypted password.
Please add Before and After screenshots to the Report.

take-my-online-class-thumbnail
Play Video
pay-someone-to-take-my-online-class

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

STATUS

 

STEP 4: Changing User Specifications

The command below grants user with UPDATE privilege to Employee table:
Mysql> GRANT UPDATE on *.Employee TO ‘user name’@‘localhost’ WITH GRANT OPTION;
Press Enter.
Where
*.Employee – to all databases, Employee table;
Mysql>flush privileges;
Press Enter.
Mysql>quit
To show grants, log in again and type the command:
Mysql>show grants for ‘username’@’ localhost’;
The result set will include grants for the user and encrypted password.
Please add Before and After screenshots to the Report.

Part 2: Using MySQL Workbench

a) Add two new users. Grant ‘superuser’ 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 superuser access for User 1, please write a 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 a query to SELECT, DELETE, INSERT, UPDATE from any created table. (Note: the Only SELECT query will be eligible. DELETE, INSERT, UPDATE will result in an access denied message.)
Add screenshots to Report.
b) Modify access to the second user by adding update access to the Employee table (Step 4).
Add screenshots to Report.
To prove the UPDATE privilege, please log in again as User 2 and update the COMM column in the Employee table.
MYSQL> UPDATE Employee SET COMM = 0.1;

STEP 1: Creating a new user using MySQL Workbench

To start, launch Start, choose MySQL Workbench, Press Enter.
Choose your schema on the Home page to connect to MySQL Server.
Enter password; Press OK.
On the left part of the screen, under the Schema, choose your database schema.
Under the Management, click User and Privileges, Enter password to connect to MYSQL Server.
Screen Administration: User and Privileges allows you to add a new user.
Click Add Account button and fill required information in Login screen.
Repeat for the second user.
Please add screenshots to the Report.

STEP 2: Finding information on users.

STEP 3: Finding user privileges.

STEP 4: Listing privileges associated with a role.

Complete Account Limits, Administrative Roles, and Schema Privileges tabs for User 1 and User 2.
Please add screenshots to the Report.

STEP 5: Changing user specifications. Assigning users to a role.

Add UPDATE privilege on Administrative Roles tab for User 2.
Please add screenshots to the Report.

STEP 6: Verifying role content.

Click on Create a new SQL tab for executing a query (located on the left corner below the File tab) to start the new Query page.
Please prove superuser privilege for user 1 by writing and executing SELECT, INSERT, DELETE, UPDATE statements.
To prove the UPDATE privilege for User 2, log in again as User 2 and update COMM column in Employee table.
UPDATE Employee SET COMM = 0.1;
Please add screenshots to the Report.

This concludes the Lab for Week 3.

Facebook
Twitter
Reddit
Pinterest
WhatsApp
Email
pdf-answers
Get Solved Answers
$2.99
Add to cart

GET QUICK PRICE ESTIMATE FOR THIS TASK

WHY CHOOSE US

  • Over 300 Experts to Work on Your Papers
  • 100% Privacy and Confidentiality
  • Amazing Discounts and Special Offers
  • Delivery within Every Deadline Level
  • Secure Payment Process
  • High-Quality Papers
  • 24/7 Live Customer Support
  • Free Revisions If Required
  • Fair & Cheap Prices
  • Rated 4.9/5 By Students

COMPLETED TASKS

SOCS 325 Week 8 Final Exam (Version 2)

July 13, 2020

SOCS 325 Week 8 Final Exam (Version 1)

July 13, 2020

SOCS 325 Week 8 Final Exam (Collection)

July 13, 2020

SOCS 325 Week 8 Collaborative Group Project Discussion

July 13, 2020

SOCS 325 Week 7 Bundle: Assignments + Group Project + Discussions

July 13, 2020

SOCS 325 Week 6 Bundle: Assignments + Discussions

July 13, 2020

SOCS 325 Week 5 Bundle: Assignments + Discussions

July 13, 2020

SOCS 325 Week 4 Midterm (Version 4)

July 13, 2020

Homework Provider

Facebook-f Twitter Pinterest Whatsapp Reddit Envelope

WE ACCEPT

PayPal
VISA Light
AMERICAN EXPRESS LIGHT
Bitcoin
  • Take My Online Class
  • Do My Case Study
  • Take My Online Exam
  • Online Class Help
  • Do My Homework
  • Take My Online Test
  • Original Homework Help
  • Premium Plagiarism Checker
  • Take My Midterm Exam
  • Research Paper Writing
  • Case Study Writing Help
  • Dissertation Writing Service
  • Online Coursework Help
  • Pay Someone To Write My Paper
  • Pay For Online Classes
  • Programming Classes Help
  • MyMathLab Answers
  • MyStatLab Answers
  • MyAccountingLab Answers
  • Need Help With Online Class
  • Cheap Assignment Help
  • Write My Online Essay
  • Online Student Problems
  • Math Homework Help

Contact Us

  • [email protected]
  • WhatsApp (781) 656-7669
  • twitter.com/hwp_helper
  • fb.com/homeworkprovidercom
  • Privacy Policy
  • Terms of Use
  • DMCA
  • Cookie Policy
  • Money Back Guarantee
  • Premium Plagiarism Checker
  • Contact Us

HomeworkProvider.com is not endorsed or affiliated by any university or college. The services provided are meant to assist the client by providing a guideline and the product provided is intended to be used for research or study purposes.

© 2013-2020 HomeworkProvider. All rights reserved.

ORDER THIS
WHATSAPP

Yay! You are just one step away to get rid of homework stress

  • How It Works
  • Testimonials
  • We are committed to ensuring that your information is secure with us
hire-an-expert-to-do-my-exam

Don't Waste Your Time Searching For Old Plagiarized Courses

Get Your Job Done By Our Anonymous Quality Experts

  • How It Works
  • Reviews
  • 24/7 Support
doc icon homework provider

CIS 155 Lab Help, Leslie​
Thank you for doing my CIS 115 lab. Homework Provider is the best.

Rated By Client
 5/5
doc icon homework provider

Dream Service, William
Thanks God, you came to my rescue. Thanks for your help.

Rated By Client
 5/5
doc icon homework provider

Mind blowing service, Eddie
I could have failed quite a few exams if you guys did not help me

Rated By Client
 5/5
doc icon homework provider

Got A grade in final exam, John
I still couldn’t believe I got an A grade in my exam. Highly vouched service.

Rated By Client
 5/5
doc icon homework provider

Linda, opted for private tutoring
Subscribed to get online class help for devry acct 212 week 1-8 class​​

Week 5 65%
doc icon homework provider

Acct Course Project, Ryan
Thanks a lot to my writer who followed all my requirements.

Rated By Client
 5/5
xls-icon

Genuine service, Steven
The research paper was much more than I expected! Thanks a lot.

Rated By Client
 4.5/5
doc icon homework provider

Karen, opted for private tutoring
Subscribed to get online class help for liberty BUSI 536 week 1-8 class.

Week 7 88%
doc icon homework provider

Marcus, opted for private tutoring
Subscribed to get online class help for ashford psy week 1-5 class.

Week 3 58%
doc icon homework provider

I got A grade in class, Amanda
with the help of homework provider I made it to pass my acct 505 class.

Rated By Client
 5/5