Sams Teach Yourself SQL in 24 Hours, Second Edition

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 ...