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:
Answer rating: 63% (11 reviews)
The user needs the references privilege on r2 The reason fo...View the full answer
Answered By
Junaid ahmed
I am an English language professor with years of experience In Teaching English Language and Literature. I like to help people in the various difficult matter.
5.00+
2+ Reviews
10+ Question Solved
Related Book For
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
Question Posted:
Students also viewed these Computer science 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...
-
Derive(16-24). (16-24) Ein 4a? In 72 De Eout
-
The Arizona Corporation reported positive net income but negative cash flow from operations. Further, despite the negative cash flow from operations, the company continued to pay its regular dividend...
-
The internal control procedures in Naperville Company provide that: 1. Employees who have physical custody of assets do not have access to the accounting records. 2. Each month, the assets on hand...
-
A BBB - rated corporate bond has a yield to maturity of 1 1 . 0 % . A U . S . Treasury security has a yield to maturity of 9 . 3 % . These yields are quoted as APRs with semiannual compounding. Both...
-
The Engel expenditure curve relates a consumer's expenditure on a commodity to his or her total income. Letting Y = the consumption expenditure on a commodity and X = the consumer income, consider...
-
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.
-
A presidential election poll contacts 2,000 randomly selected people. Should the number of people that support candidate A be analyzed using discrete or continuous probability models?
-
MSI's educational products currently are sold without any supplemental materials. The company is considering the inclusion of instructional materials such as an overhead slide presentation, potential...
-
Read the job descriptions. Are they accurate descriptions for jobs that you would be applying for? Why or why not? Are there jobs for which you cannot find an appropriate match? Why do you think this...
-
Calculate the future value of the following annuities, assuming each annuity payment is made at the end of each compounding period. (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use tables, Excel,...
-
1 Find a Laurent Series for f(z) = which is valid in the domain (z-4i) {z: 4
-
A 4.20 kg block is attached to a spring with spring constant 2140 N/m. The block is resting on a horizontal, frictionless surface. It is pulled 4.20 cm from the equilibrium position and given an...
-
A helicopter is using a steel cable to lift a 2100-kg jeep (see the figure). The unstretched length of the cable is 16 m, and its radius is 5.0 10-3 m. By what amount does the cable stretch when the...
-
6. (Potential Energy and Conservation of Energy) What should be the spring constant k of a spring designed to bring a 1200-kg car to rest from a speed of 95 km/h so that the occupants undergo a...
-
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...
-
Redwood Industries has EBIT of $450 million, interest expense of $175 million, and a corporate tax rate of 35%. The total of Rosewood's net income and interest payments is closest to:
-
Jayden is evaluating purchasing a sandwich shop from his friend. Currently, the shop sells sandwiches for $10 each with a variable cost of $3 per sandwich. The fixed costs for the shop are $1,400....
-
To create a sample program personnel budget and to evaluate your budget. Scenario: You are the director of a small early childhood program, forecasting for your upcoming year. Your program will have...
Study smarter with the SolutionInn App