Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the  Food Truck Company Database

 

1. Create 2 new users statement for the database. One of the new user names should be based on yourself containing your name.  
   
    
2. 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
   
    
3. 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
   
    

 

 

1. A SQL Script containing the SQL commands to create the database, create the table, and insert the sample test data into the table.

 

1. A SQL Script containing the DCL SQL Statements.
   
    
2. Combine the script together to form a single file.

 

Safari File Edit View History Bookmarks Develop Window Help media.cheggcdn.com Assignment: Data Control Statements for the Homework Database: for... name food truck-2 1 page Dashboard food truck-2 D > date Search time phoneNo costumer purchase M sales and services transaction No email M detailsof trans costName buys M point of sale buys name M price serviceNo m products payment amount repair services productNo reorder level quantity on hand supplied by id name vendors W O A name identification No price description of service L D Sat Dec 10 9:15 PM phpt04Aid 1,024x724 pixels Screen Shot 22-12...17.04 PM X CIS114 Atom