Question: Suppose a user creates a new relation r1 with a foreign key referencing another relation r2. What authorization privilege does the user need on r2?

Suppose a user creates a new relation r1 with a foreign key referencing another relation r2. What authorization privilege does the user need on r2? Why should this not simply be allowed without any such authorization?

Step by Step Solution

★★★★★

3.41 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The user needs the references privilege on r2 The reason fo... 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 Database System Concepts Questions!

Why do we need international accounting standards? Why not simply let each country develop and use its own standards and let it go at that?

Should a CEO be allowed to serve on another companys board of directors?

Suppose that the two return random variables R1 and R2 in Examples 4.2.2 and 4.2.3 are independent. Consider the portfolio at the end of Example 4.2.3 with s1 = 54 shares of the first stock and s2 =...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

provide answers to all questions (a) What are the main criteria to be considered in the design of a line drawing algorithm for a raster graphics display? [2 marks] (b) Describe an algorithm to fill a...

For each of the following joint pdfs, find FX,Y (u, v). (a) f X,Y (x, y)= 1/2 , 0 x y 2 (b) f X,Y (x, y)= 1/x , 0 y x 1 (c) f X,Y (x, y)=6x, 0 x 1, 0 y 1x

Biebs thinks he's a smart investor. He has an average tax rate of 35% and a marginal tax rate of 40%. To try to get a good investment deal, he purchases $6,000 of Labour Sponsored Venture Capital...

Using activity - based costing information to make decisions that increase profits while satisfying customers ' needs is

4. If the money supply fell by 10 percent, a monetarist would expect nominal GDP to __________. LO19.1 a. Rise. b. Fall. c. Stay the same.

Repeat Exercise R-14.28 for Figure 14.10 that illustrates a BFS traversal. Repeat Exercise Describe the meaning of the graphical conventions used in Figure 14.9 illustrating a DFS traversal. What do...

Repeat Exercise R-14.28 for Figure 14.8 that illustrates a directed DFS traversal. Repeat Exercise Describe the meaning of the graphical conventions used in Figure 14.9 illustrating a DFS traversal....

In the merge-sort tree shown in Figures 12.2 through 12.4, some edges are drawn as arrows. What is the meaning of a downward arrow? How about an upward arrow? Figures 12.2 Figures 12.4 85 24 45 17 31...

Suppose that in January 2006, Kenneth Cole Productions had sales of $500 million, EBITDA of $58.2 million, excess cash of $96 million, $5.1 million of debt, and 21 million shares outstanding. Use the...

Question 7 (2 points) Which of the following is the major advantage to privately placing a bond? 1) The direct placement offers tax advantages. 2) The bond has less risk. 3) The firm saves issuing...

An Excel model based on the FinCorp example discussed in the text is shown below. The model allows you to use any variety of options, stock, and lending or borrowing with a set investment amount and...