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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer Create two new users for the Small Commuter Airline Reservation Database CREATE USER johndoe IDENTIFIED BY password123 CREATE USER arya IDENTIF... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create three or more SQL Data Control Language (DCL) Statements using the Homework Database: for the CCP Vehicle Loan System Database Create 2 new users statement for the database. One of the new...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

You have been employed to create program to assist the manager of a coffee shop. You decide to make a prototype application in Java to show what you can do, and to be able to ask the manager what...

Bollobs and Chung proposed a hybrid model that combines a 2-ring on $V$ vertices ( $V$ is even), plus a random matching. A matching is a graph in which every vertex has degree 1. To generate a...

If V = 2z sin , calculate the energy within the region defined by 1 Answered: 1 week ago

12. What is a situation analysis?

Use the plot of the standardized Pearson residuals versus the observation index given in Figure 10.13 to answer the following questions. (a) Does this residual plot suggest there are observations for...

The board of commissioners of the City of Hartmoore adopted a General Fund budget for the year ending June 30, 2010, that included revenues of $1,000,000, bond proceeds of $400,000, appropriations of...

You are bullish on Google stock. The current market price is $60 per share, and you have $12,000 of your own to invest. You borrow an additional $12,000 from your broker at an interest rate of 5.8%...

Improv Club (IC) features entertaining improvisational theatre performances. The theatre features a range of shows and talented performers. IC prepares financial statements on an annual basis. The...

You have been asked to value Ausbiz, a private company, using an excess earnings method, given the following information: Working capital balance = $365,000 Fair value of fixed assets = $725,000 Book...

Fill in the amounts for the Norfolk Southern statement of changes in retained earnings. Note: Use negative signs with your answers, when appropriate. Norfolk Southern Inc. Consolidated Statements of...

In a sample of 3,200 registered voters, 1,440, or 45%, approve of the way the president is doing his job. A political pollster states, "Forty five percent of all voters approve of the president."...

Harris Fabrics computes its plantwide predetermined overhead rate annually on the basis of direct labor-hours. At the beginning of the year, it estimated that 30,000 direct labor-hours would be...

Inventory Microbucks Computer Company makes two computers, the Pomegranate II and the Pomegranate Classic, at two different factories. The Pom II requires 2 processor chips, 16 memory chips, and 20...

Calculate the Critical Ratios (CR): (Enter all responses rounded to two decimal places.) Job CR 1 The following jobs are waiting to be processed at Jeremy LaMontagne's machine center. Today is day...

Problem 6-03A a, b1-b2, c (Video) Problem 6-03A a, b1-b2, c (Video) Sheridan Company had a beginning inventory on January 1 of 160 units of Product 4-18-15 at a cost of $20 per unit. During the year,...

Jax Incorporated reports the following data for its only product. The company had no beginning finished goods inventory and it uses absorption costing. $ 57.30 per unit $ 10.30 per unit $ 7.80 per...

Are there any restrictions on the tables when using the UNION command? If so, what are these restrictions?

Use a Web browser to find three examples of static Web pages and three examples of dynamic Web pages, and note the URLs for each page you find. Explain the purpose of each page and why you believe it...

Write the SQL commands to grant the following privileges: a. User Stetson must be able to retrieve data from the Customer table. b. Users Webster and Bremer must be able to add new orders and order...

=+18. Four new word processing software programs are to be compared by measuring the speed with which various standard tasks can be completed. Before conducting the tests, researchers note that the...

=+a. Write an expression for the weighted average of the sample proportions, using the stratum sizes as weights.

=+yni for each i).