Data Security

Password protect the database you created for your individual assignment in Week Three.

Create a matrix to indicate the permissions (read, insert, delete, modify) you would grant to different users of your database.

Create at least two different users and implement their permissions using SQL statements.

Submit the following deliverables to your instructor:

The steps you took to password protect the database

The matrix

The SQL code for creating the users and implementing their permissions

Using either MySQL, SQL Server, or SQL Manager. Need screenshots and coding in word.

  1. 👍 0
  2. 👎 0
  3. 👁 97
asked by kelsee

Respond to this Question

First Name

Your Response

Similar Questions

  1. IT

    In this assignment, you are going to be gathering information about the future students of NSU at one of our open houses. Since there will be plenty of student candidates with interests on different programs, I would like you to

    asked by Tiffany on August 23, 2007
  2. Data networks and Telecommunication

    Other than the explanation below How can switches help reduce network security problems? ________________ Switches can be used to disallow access to a network by requiring authentication to the server to all computers that plug in

    asked by Melbut on January 18, 2012
  3. Computers

    Please help, this is the question: Before you create a pivot table, it is important to ________. Create a database ( I think it's this one) Sort a database Filter a database Format a database

    asked by Frog on March 13, 2019
  4. DBM 381

    Create a detailed ERD using the Entities and Attributes document provided with the Service Request. Create a Microsoft® Access® database using the ERD created above. You do not need to include keys and relationships at this

    asked by Minnie on September 7, 2012
  5. ED TECH

    What is the purpose of filters in a database? A. Filters allow you to see only the records that meet specific criteria. B. Filters delete unnecessary data. C. Filters create charts based on specific criteria. D. Filters put data

    asked by Anonymous on November 13, 2018
  6. math

    a database with an availibility of 93.4% is accessed via a network with an availibility of 99.2% on average for how much time in a week would a user be unable to retrive data from the database? i calculated around 12 hrs.is it

    asked by kenji86 on April 14, 2010
  7. Databaes

    Show me an example on how I can create and establish a database of a library and a security firm?

    asked by Jnr John on June 30, 2013
  8. Programming

    How can I lock columns on Excel and keep them locked when I put them into a Palm handheld? I'm not entirely sure what you mean by 'locked'. If you mean protecting them these are the procedures. In protecting cells, we actually do

    asked by bill on September 9, 2006
  9. Math

    A student created a 6 character computer password, the password strts with 4 digits, the first of which is he number 3, followed by 2 letters, the firsr of which is a consonant. How many different passwords are possible if

    asked by Babs on May 12, 2016
  10. IT Information Systems Technology

    Why are database management systems important in the business community? Give atleast two reasons. Let's begin with what a database is. A database is a collection of data records. These records are on your computer and a program

    asked by Maria on March 26, 2007

More Similar Questions