4)Write, but do not execute, the commands to grant the following privileges: a.

Question

4)Write, but do not execute, the commands to grant the following privileges: a. User Rodriquez must be able to retrieve data from the BOOK table. b. Users Gomez and Liston must be able to add new books and publishers to the database. c. Users Andrews and Zimmer must be able to change the price of any book. d. All users must be able to retrieve the book title, book code, and book price for every book. e. User Golden must be able to add and delete publishers. f. User Andrews must be able to create an index for the BOOK table. g. Users Andrews and Golden must be able to change the structure of the AUTHOR table. h. User Golden must have all privileges on the BRANCH, BOOK, and INVENTORY tables. A) GRANT SELECT ON BOOK TO Rodriquez; B) GRANT INSERT ON HenryBooks TO Gomez, Liston; C) GRANT UPDATE (PRICE) ON BOOK TO Andrews, Zimmer; D) GRANT SELECT (BOOK_CODE, TITLE, PRICE) ON BOOK TO PUBLIC; E) GRANT UPDATE, DELETE ON PUBLISHER_NAME TO Golden; F) GRANT INDEX ON BOOK TO Andrews; G) GRANT ALTER ON AUTHOR TO Andrews, Golden; H) GRANT ALL ON BRANCH, BOOK, INVENTORY TO Golden; This what I got so far.

Explanation / Answer

whatever answers you got are correct. Please go ahead and execute and let me know if you need any other guidance

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.