Prog3 - CNT 4714 Programming Assignment#3 Fall 2010 Title Program Assignment 3 MySQL Database Administration Points 100 points Due Date Monday

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Page 1 Title: “Program Assignment 3: MySQL Database Administration” Points: 100 points Due Date: Monday October 11 th by 11:55 pm (WebCourses Time) Objectives: To gain familiarity with the MySQL DBMS environment and to administer user permissions as a DBA. This project is designed to give you some experience using the various features of the MySQL Administrator tool. Description: This assignment involves the creation, population, and administration of user (client) accounts on a MySQL database. By now you should have downloaded and set-up MySQL on your system and be familiar with the MySQL server and MySQL environment. This assignment is important because it is the first step toward developing multi-tier distributed applications. Be sure that you are using MySQL 5.1.38 or higher for this assignment (illustrations shown using MySQL 5.1.50 – the most recent version). Assuming that you have already downloaded and installed the MySQL server, during which you will have defined the “root” (or superuser) user, the first step in this assignment is to login as the root user and execute/run the script to create and populate the backend database. This script is available on the course assignment page and is named “prog3dbscript.sql”. This script creates a database named prog3 . The second step is to create authorizations for four client users (in addition to the root user) named client1, client2, client3, and client4. Be sure that your root user has all permissions on the prog3 database. Use either SQL Grant statements from the command line or the MySQL Administrator tool to check and set permissions for the clients as follows: Register the new user named client1 (you can decide whether or not to assign them a password) and assign to this user only the following permissions: 1. Grant table level selection on shipments relation. 2. Grant table level insertion on suppliers relation. 3. Grant table level update on parts relation. 4. Grant column level update and selection on attribute city in jobs relation. Next, register the new user named client2 and assign to this user only the following permissions: 1. Grant table level insertion on shipments relation. 2.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/24/2011 for the course CNT 4714 taught by Professor Llewellyn during the Fall '10 term at University of Central Florida.

Page1 / 7

Prog3 - CNT 4714 Programming Assignment#3 Fall 2010 Title Program Assignment 3 MySQL Database Administration Points 100 points Due Date Monday

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online