Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Small
Question:
Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the Small Commuter Airline Reservation 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.
If you are using comments in the script files or files, you must use them correctly. The script must run continuously. Any commands that do not operate correctly due to improperly formatted comments will not be assessed in the final point accumulation for the assignment.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last