Assignment: Data Control Statements for the Homework Database: Art Exhibition Database.
- Due Dec 8, 2024 by 11:59pm
- Points 100
- Submitting a text entry box or a file upload
- File Types sql
- Available Dec 2, 2024 at 12am - Dec 9, 2024 at 11:59pm
This is a 100 Point Assignment
Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: Art Exhibition Database
- Create a new user statement for the database. The user name should be based on yourself containing your name.
- Statements that grant privileges to the new user. Statements granting privileges to at least 2 of the tables in the assigned database
- Statements that revoke privileges to the new user. Statements revoking privileges to at least 2 of the tables in the assigned Database
- 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.
Find Rubric