Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Food
Fantastic news! We've Found the answer you've been seeking!
Question:
Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Food Truck Company Database
- Create 2 new users statement for the database. One of the new user names should be based on yourself containing your name.
- Statements that grant privileges to the two new users. Statements granting privileges to at least 2 of the tables in the assigned database to the two new users
- Statements that revoke privileges from the two new users. Statements revoking privileges to at least 2 of the tables in the assigned Database to the two new users
- A SQL Script containing the SQL commands to create the database, create the table, and insert the sample test data into the table.
- A SQL Script containing the DCL SQL Statements.
- Combine the script together to form a single file.
Related Book For
Principles Of Information Security
ISBN: 9780357506431
7th Edition
Authors: Michael E. Whitman, Herbert J. Mattord
Posted Date: