Consider the following 4 steps in a series of GRANT statements.User AGRANT INSERTON DoctorWITH GRANT OPTIONGRANT INSERTON DoctorUser CUser BGRANT INSERTON DoctorWITH GRANT OPTIONGRANT INSERTON DoctorUser DIf User A executes the following statement at the 5th step, what will be the effectof this REVODKE on User C and User D?REVOKE INSERTON DoctorFROM User BCASCADECan insert on the tableCannot insert on the tableUser CUser D Now consider the following data in the Doctor table.DoctordoctorNopecialtycolary hospitalNonameRobert Donald CardiologistXin WangD201180000H117D205NeurologistDermatologist 140000Pediatrician225000H120D211David FordH120D216Alisa Garcia165000H126

User C can still insert into the database, doctor, because it still has insert/write privilege from…

Answered: Consider the following 4 steps in a…

Consider the following 4 steps in a series of GRANT statements. User A GRANT INSERT ON Doctor WITH GRANT OPTION GRANT INSERT ON Doctor

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Please provide concrete examples of how calls and returns fall into the overall scheme.

A: In modern programming, understanding the role of function calls and returns is crucial for creating…

Q: Input and run the VALID_DEPTID function to see how it works. CREATE OR REPLACE FUNCTION valid_deptID…

A: In the given function valid_deptID will return a boolean value.

Q: In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial…

A: According to the Question below the Solution: As per our guidelines we are supposed to answer?️…

Q: A 'SubWay' sub order has many items that may be included on the order. The order may contain choices…

A: Below is an Entity-Relationship Diagram (ERD) that models the entities, attributes, relationships,…

Q: 12 return: ERROR 1410 (42000) at line

A: Given : Task 11 & 12 return: ERROR 1410 (42000) at line 1

Q: The following code would include: SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_PRICE < ANY (…

A: Your answer is given below.

Q: Submit Test Reader Which type of function best models the relationship between the number of days…

A: Modeling the relationship between the number of days and remaining inventory is crucial for…

Q: The problem with Access forms is that they cannot be customized. True False

A: Access forms are used to present information as per the requirement.

Q: eglecting air friction) is Gravity on Mars is, g = 3.711 m/sec2. Create a table of time…

A: g=3.711; d=@(t).5*g*t.^2; %% a t1=(0:10:120)'; dist1=d(t1);…

Q: In order for a player to navigate your game, you will need to develop a function or functions using…

A: Solution: Given, Show the player the different commands they can enter (such as "go North", "go…

Q: A property that does not exist has which of the following values? Question 6 options: A)…

A: Correct Answer is Option A) null Because a null value doesn't belong to any of the types in the…

Q: Ex1. Dorm, Meal Plan, and miscellaneous options Calculator: A university has the following…

A: Hello

Q: Friend functions are members of the class. True False

A: In C++, a friend function is a function that is not a member of a class, but has access to the…

Q: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing…

A: sql command for the question is given in step 2

Q: Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should…

A: Statement to copy content of one table into another table in SQL Statement which delete a table in…

Question

Consider the following 4 steps in a series of GRANT statements.
User A
GRANT INSERT
ON Doctor
WITH GRANT OPTION
GRANT INSERT
ON Doctor
User C
User B
GRANT INSERT
ON Doctor
WITH GRANT OPTION
GRANT INSERT
ON Doctor
User D
If User A executes the following statement at the 5th step, what will be the effect
of this REVODKE on User C and User D?
REVOKE INSERT
ON Doctor
FROM User B
CASCADE
Can insert on the table
Cannot insert on the table
User C
User D

Now consider the following data in the Doctor table.
Doctor
doctorNo
pecialty
colary hospitalNo
name
Robert Donald Cardiologist
Xin Wang
D201
180000
H117
D205
Neurologist
Dermatologist 140000
Pediatrician
225000
H120
D211
David Ford
H120
D216
Alisa Garcia
165000
H126

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

S1:Grandfather-father-son record retention is a general control that would most likely assist an entity whose system analyst let the entity in the middle of a major project.$2:A hot site can be used when the downtime is acceptable to the business without breaching any legal requirements. A. Both Statements are trueB. Only the first statement is trueC. Only the second statement is trueD. None of the statements are true
3. Which among the following shows a valid use of the Direction enumeration as a parameter to the moveCharacter function? Select al that apply. enum Direction { case north, south, west, east}func moveCharacter(x: Int, y: Int, facing: Direction) {// code here} moveCharacter(x: 0, y: 0, facing: .southwest) moveCharacter(x: 0, y: 0, facing: Direction.north) moveCharacter(x: 0, y: 0, facing: .south) moveCharacter(x: 0, y: 0, facing: Direction.northeast)
assign(self, assignment:Assignment) -> AssignmentResult: """ This function is to simulate the process of the student receiving an assignment, then working on the assignment, then submitting the assignment and finally receiving grade for the assignment. This function will receive an assignment then a grade should be calculated using the following formula: grade = 1 - (Student's current energy X Assignment difficulty level). The min grade a student may receive is 0% (0) After the grade is calculated the student's energy should be decreased by percentage difficulty. Example if the student has 80% (.8) energy and the assignment is a difficultly level .2 there final energy should be 64% (.64) = .8 - (.8 * .2). The min energy a student may have is 0% (0) Finally the grade calculated should be stored internally with in this class so it can be retrieved later. Then an Assignment Result object should be created with the student's ID, the assignment…
$1:Automated tracking of changes made to data, associating the change with a specific user is an input control.S2:Comparison of individual transactions to previously recorded transactions to previously recorded transactions to match fields is a processing control. A. Both Statements are trueB. Only the first statement is trueC. Only the second statement is trueD. None of the statements are true
The following statements represent a "normal flow" use case for placing an online order for a meal from a restaurant that delivers food to one's home. The steps are out of order. You are to number them in the natural order of beginning to end. Question 34 options: App displays ordered menu items, individual prices, and total price, including taxes and delivery charge. Patron either confirms meal order (continue normal flow) or requests to modify meal order ( return to step 2 ). Patron opens app to view menu for a specific date. Patron selects one or more food items from menu. The app displays menu of available food items and the daily special. Patron selects a delivery time and specifies the delivery location. Patron indicates that meal order is complete. App sends patron an email message confirming order details, price, and delivery instructions. App displays available delivery times for the delivery date. Patron specifies payment method. App sends patron an…
Create the following variables that can be used to store values. Use the naming conventions as outlined in the Algorithms/Pseudocode Guidelines document in the course resources section of the course. 1. test grade for student test 2. total of all test grades added together 3. the average for the test grades Create an assignment statement that sets the value of the variable you created to store the value of all test grades added together to zero. You may refer to Table 6.1 in Chapter 6 for examples. Create an input statement to input the value for the first test grade for the variable you created. Create an algorithm that will obtain the test grade for three students, add the test grades together, calculate the average of the test grades, and output the average. Use a count-controlled loop to create the algorithm. Use the information from your answers to questions 3, 4, and 5 in the creation of your algorithm. Also use information and examples from Chapter 6…