Consider a table T(A,B,C) with owner Amy, and the following sequence of statements related to privileges on T. Each statement is numbered and prefaced with the user issuing it. 1 Amy: Grant Select on T to Bob With Grant Option 2- Bob: Grant Select on T to Carol With Grant Option 3- Carol: Grant Select(A,C) on T to David With Grant Option 4- Carol: Grant Select(A,B) on T to Eve With Grant Option 5 Amy: Grant Select on T to Eve 6- Amy: Grant Select(C) on T to Frank 7 David: Grant Select(A,C) on T to Frank With Grant Option 8- Eve: Grant Select(A,C) on T to Frank 9 David: Grant Select(A) on T to Gary 10 Eve: Grant Select(A) on T to Gary 11 Amy: Revoke Select on T From Eve Restrict 12 Carol: Revoke Select(A,C) on T From David Restrict 13 - David: Revoke Select(A) on T From Eve 14 Bob: Revoke Select on T From Carol Cascade 15 Amy: Revoke Select on T From Bob Restrict a) (6%) Present a Grant diagram describing all authorizations related to privileges on T. b) (3%) Which of the Grant statements, if any, would be disallowed? c) (3%) Which of the Revoke statements, if any, would be disallowed? d) (3%) After the statements complete execution (excluding any disallowed ones), what privileges does user Frank have on table T?

Consider a table T(A,B,C) with owner Amy, and the following sequence of statements related to privileges on T. Each statement is numbered and prefaced with the user issuing it. 1 Amy: Grant Select on T to Bob With Grant Option 2- Bob: Grant Select on T to Carol With Grant Option 3- Carol: Grant Select(A,C) on T to David With Grant Option 4- Carol: Grant Select(A,B) on T to Eve With Grant Option 5 Amy: Grant Select on T to Eve 6- Amy: Grant Select(C) on T to Frank 7 David: Grant Select(A,C) on T to Frank With Grant Option 8- Eve: Grant Select(A,C) on T to Frank 9 David: Grant Select(A) on T to Gary 10 Eve: Grant Select(A) on T to Gary 11 Amy: Revoke Select on T From Eve Restrict 12 Carol: Revoke Select(A,C) on T From David Restrict 13 - David: Revoke Select(A) on T From Eve 14 Bob: Revoke Select on T From Carol Cascade 15 Amy: Revoke Select on T From Bob Restrict a) (6%) Present a Grant diagram describing all authorizations related to privileges on T. b) (3%) Which of the Grant statements, if any, would be disallowed? c) (3%) Which of the Revoke statements, if any, would be disallowed? d) (3%) After the statements complete execution (excluding any disallowed ones), what privileges does user Frank have on table T?

Similar questions

Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
The several kinds of joins and an explanation of each one
What are the differences between the JOIN … USING and JOIN … ON approaches for joining tables?
Add the ends to the relations on the Crows Foot ERD for the business rules of the XYZ Company's motor pool (a motor pool typically is a group of vehicles that are temporary assigned to employees to drive for business purposes): Each time an employee wants a vehicle a new assignment is made. An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle. A vehicle may have multiple assignments. The XYZ location at the end if the assignment is stored in the assignment. It is assumed tht the assignment begins at the destination of that vehicles prior assignment. An assignment may have the status of Assigned, Out, or Returned. A vehicle may only be "Out" on one assignment and an employee may only have one assignment "Out".
How do we choose a model for Microsoft Access table design?
Let R and K be two relations under a join operation. Assume that m = |R| and n = IKI, then the maximum and minimum sizes of the join, respectively, are: 1. m+n and 0 II. mn and 0 III. m+n and m-n IV. mn and m+n III O IV =
Explain why an index is only helpful if the values of an attribute vary enough.
What is metadata, exactly? For a result set, what is metadata? Result set information might be helpful in some situations.
Could you please explain about foreign key with an example?