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.43 Rating (182 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The user needs the SELECT authorization on r2 in order to be a... 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...

Mitchell Energy and Development Corporation was one of the countrys largest oil and gas producers before it was purchased by Devon Energy. Some years ago, the notes to its financial statements...

Which of the following is true of morals and values. The terms morals and values define a society and not an individual. The term morals is used to refer to an individual while the term values is...

QUESTION 2 Strong Al is when you have a machine that displays all the behavior that you would expect from a full fledged artificial person. Weak Al implements a limited part of mind, it is focused on...

Are you ever ambivalent about a purchase decision? Is it better to make a snap decision or to make no decision at all? General Patton called the no-decision strategy readyaim-aim-aim-aim syndrome. In...

Write queries in XSLT and in XPath on the DTD of Exercise 10.3 to list all skill types in Emp. Emp = (ename, ChildrenSet setof (Children), SkillsSet setof (Skills)) Children = (name, Birthday)...

Write a query in XQuery on the XML representation as shown below to find the total balance, across all accounts, at each branch. A-101 Downtown 500 A-102 Perryridge 400 A-201 Brighton 900 Johnson...

Write a query in XQuery on the XML representation as shown below to compute the left outer join of customer elements with account elements. account-number ID #REQUIRED owners IDREFS #REQUIRED >...

Fill in the table below for the following zero-coupon bonds, all of which have par values of $1,000. Use semi-annual periods. (Do not round intermediate calculations. Round your answers to 2 decimal...

You are about to prepare a set of projections for a business that is operating in a highly, competitive, mature industry. Sales are growing broadly in line with the economy, and this is expected to...

>-1.] E-business differs from traditional business in that: A) traditional business caters to business-to-business deals, which do not include direct selling B) e-business carries out the goals of...