Suppose a user creates a new relation r1 with a foreign key referencing another relation r2. What

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? Why should this not simply be allowed without any such authorization?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database System Concepts

ISBN: 9780078022159

7th Edition

Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan

Question Posted: Jun 13, 2022 07:45 AM

See More 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 =...
McGuire Industries prepares budgets to help manage the company. McGuire is budgeting for the fiscal year ended January 31, 2021. During the preceding year ended January 31, 2020, sales totaled $9,200...
Assume that the population of heights of men has a normal distribution with a mean of 69.5 in. and random samples of 100 men result in sample mean heights with a mean of 69.5 in. and a standard...
Suppose the daily demand function for pizza in Berkeley is Qd = 1,525 - 5P. The variable cost of making Q pizzas per day is C(Q) = 3Q + 0.01Q2. There is a $100 fixed cost (which is avoidable in the...
What is the relationship between false positive rate and sensitivity?
The financial statements of The Hershey Company appear in Appendix B, following the financial statements for Tootsie Roll in Appendix A. Instructions (a) Based on the information in the financial...
2 16 points On August 1, 2021. Trico Technologies, an aeronautic electronics company, borrows $19.7 million cash to expand operations. The loan is made by FirstBanc Corp. under a short-term line of...
The shelf life of a carbonated beverage is of interest. Ten bottles are randomly selected and tested, and the following results are obtained: Days 108 138 124 163 124 159 106 134 115 139 (a) We would...
Suppose user A, who has all authorization privileges on a relation r, grants select on relation r to public with grant option. Suppose user B then grants select on r to A. Does this cause a cycle in...
Explain why, when a manager, say Satoshi, grants an authorization, the grant should be done by the manager role, rather than by the user Satoshi.
The Pitot tube on a supersonic aircraft (see Video V3.8) cruising at an altitude of $30,000 \mathrm{ft}$ senses a stagnation pressure of 12 psia. If the atmosphere is considered standard, determine...
What can you do to plan ahead and educate others about the international groups? Consider How do you communicate during the meeting with your colleagues?
What do you think should be the role of personality tests in candidate selection? Do you think they should play a major, minor or no part in an organization\'s hiring decision for a job? What are...
What channels do our target customers prefer for discovering, researching, and purchasing products? How do cultural or societal shifts affect consumer attitudes and behaviors towards our products or...
What role do symbolic artifacts and rituals play in the construction and maintenance of organizational culture, and how do they influence employee identification and commitment ?
Describe all you would do and what you would consider in converting some or all of your employees to independent contractors, the rate you would pay and the reason therefor and how it would be paid....
Use the normal distribution in Exercise 16. (a) What percent of the adult males have a red blood cell count less than 6 million cells per microliter? (b) What percent of the adult males have a red...
(a) Given a mean free path = 0.4 nm and a mean speed vav = 1.17 105 m/s for the current flow in copper at a temperature of 300 K, calculate the classical value for the resistivity of copper. (b)...
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...
44. Dryer Companys policy is to keep 25% of the next month's sales in ending inventory. If Dryer meets its ending inventory policy at the end of April and sales are expected to be 24,000 units in May...
What general conclusions can you draw about your companys liquidity, solvency and productivity based on your ratio calculations. Working Capital 2017 = $9,994 M 2016 = $10,673 M Current Ratio 2017 =...
Tami Tyler opened Tami's Creations, Incorporated, a small manufacturing company, at the beginning of the year. Getting the company through its first quarter of operations placed a considerable strain...

Suppose a user creates a new relation r1 with a foreign key referencing another relation r2. What

Question:

Step by Step Answer:

The user needs the references privilege on r2 The reason fo...View the full answer

Database System Concepts

Students also viewed these Computer science questions