Workshop
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C, "Answers to Quizzes and Exercises," for answers.
Quiz
| 1: | What option must a user have to grant another user privileges on an object not owned by the user? |
| 2: | When privileges are granted to PUBLIC, do all database users acquire the privileges, or just a listing of specified users? |
| 3: | What privilege is required to look at data in a specific table? |
| 4: | What type of privilege is SELECT? |
Exercises
| 1: | Write a statement to grant select access on a table called EMPLOYEE_TBL, which you own, to a user ID, RPLEW. It should allow RPLEW to grant privileges to another user on the same table. |
| 2: | Write the statement that revokes the connect role from both of the users in Exercise 1. |
| 3: | Write the statement that allows RPLEW to select, insert, and update the EMPLOYEE_TBL table. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.