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

See More Books

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...
The highest dew point ever recorded was 95F, recorded in Saudi Arabia. Was the air humid or dry at that time? Explain your reasoning.
A 50-lb box shaped like a 1-ft cube falls from the cargo hold of an airplane at an altitude of $30,000 \mathrm{ft}$. If the drag coefficient of the falling box is 1.2, determine the time it takes...
Midland National Bank selected a sample of 40 student checking accounts. Below are their end-of-the-month balances. a. Tally the data into a frequency distribution using $100 as a class interval and...
a. Since year 2000 STI share price had been trading below $5/share with 10-year options. Based on the Option Pricing Model and with an estimated growth of 5%, the future estimated stock price would...
Mr B aged 52 years, has earned rupees 75,00,000 out of his business. His ex-wife gifted him a car worth rupees 8 lakh. He spent a total of rupees 20 lakh during a family trip. He won a lottery of 16...
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.
Where the incidence rates for nosocomial infections per 100 neonatal admissions were calculated. What percentage developed a nosocomial infection in this unit before and after the handwashing...
How much debt does the issuer have? Has the debt level changed over the past three years? Can the increase/decrease in debt level affect their credit rating? Provide a graph that shows the debt level...
The atomic weight of aluminum (Al) is based on its only naturally occurring isotope, which has an atomic mass of 26.98153860000 u. (a) Write the complete atomic symbol for aluminum . How many...
Using the data from problem 3-24, complete the following steps: 1. Prepare a schedule to determine goodwill and to allocate fair value 2. Prepare a schedule to determine the balance in the...
Answer the following questions below. Make sure to answer the questions in full detail and avoid using bullet points. 1) What is the importance of creating a WBS in MS Project. How does this help a...
Implement a simple but a complete web server in java that is listening on port 9000 using socket programming. The user types in the browser something like http://localhost:9000/ or...
Find the Euclidean inner product u v if. (a) u = ( - i 3i), v = (3i, 2i) (b) u = (3 - 4z, 2 + i, - 6i),v = (1 + i, 2 - i, 4)
a) Show that (a, b) := {{a}, {b}} does not satisfy the ordered pair axiom. b) Determine whether each of the following statements is true or false. (Give a reason in each case): (i) {a, b} C (a, 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...
Lake Incorporated and the River, Incorporated reported net incomes of $205,000 and $164,000, respectively, for the most recent fiscal year. Both companies had 41,000 shares of common stock issued and...
What effect Eventually, BREXIT will make on EU? How it will benefit UK? What will be the possible outcome?
Merchant Company purchased property for a building site. The costs associated with the property were: Purchase price Real estate commissions Legal fees Expenses of clearing the land Expenses to...

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