Hour 19, "Managing Database Security"

Quiz Answers

1: What option must a user have to grant another user privileges on an object not owned by the user?
A1: The GRANT OPTION.
2: When privileges are granted to PUBLIC, do all database users acquire the privileges, or just a listing of specified users?
A2: All users of the database will be granted the privileges.
3: What privilege is required to look at data in a specific table?
A3: The SELECT privilege.
4: What type of privilege is SELECT?
A4: An object-level privilege.

Exercise Answers

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.
A1: 
GRANT SELECT ON EMPLOYEE_TBL TO RPLEW WITH GRANT OPTION;

2: Write the statement that revokes the connect role from both of the users in Exercise 1.
A2: 
REVOKE CONNECT ON EMPLOYEE_TBL FROM RPLEW;

3: Write the statement that allows RPLEW to select, insert, and update the EMPLOYEE_TBL table.
A3: 
GRANT SELECT, INSERT, UPDATE ON EMPLOYEE_TBL TO RPLEW;

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset