SECTION - A Database Object design Column Name Data Type Constraint (Column Level) DoctorID Number(4) Should not be empty and not repeated DoctorName Varchar2(25) Salary Number(6) Should be more than or equal to 5000 7. Make use of the Doctors table(Designed in QI: Section A) and write SQL statements to assign the following Privileges Direction: Assume that User-1, "Si_01_ITDB202" is having the Doctors table and he is giving the privileges to User-2 "S2_02_ITDB202" as follows: a) User-1: Give the permissions to allow user-2 to insert and update the data on the Doctors table. b) User-2: Display all the rows of Doctors table of User-1. c) User-2: Update the Salary of Doctorid 1002 to 2250 in the Doctors table of User-1 d) User-1: Cancel the update privilege given to User-2.
SECTION - A Database Object design Column Name Data Type Constraint (Column Level) DoctorID Number(4) Should not be empty and not repeated DoctorName Varchar2(25) Salary Number(6) Should be more than or equal to 5000 7. Make use of the Doctors table(Designed in QI: Section A) and write SQL statements to assign the following Privileges Direction: Assume that User-1, "Si_01_ITDB202" is having the Doctors table and he is giving the privileges to User-2 "S2_02_ITDB202" as follows: a) User-1: Give the permissions to allow user-2 to insert and update the data on the Doctors table. b) User-2: Display all the rows of Doctors table of User-1. c) User-2: Update the Salary of Doctorid 1002 to 2250 in the Doctors table of User-1 d) User-1: Cancel the update privilege given to User-2.
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 4.3CP
Related questions
Question
SQL
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 5 images
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning