In the final installment of this three-part series, learn about DB2's system, server, nickname, and variable privileges plus several more.
Written by Roger E. Sanders
Editor's note: This article is an excerpt from the book DB2 10.1 Fundamentals: Certification Study Guide
In DB2 for Linux, UNIX, and Windows and DB2 for z/OS, object privileges convey the right to perform certain actions against specific database objects. Part 1 of this series reviewed DB2's authorization ID, buffer pool, table space, storage group, schema, table, view, and index privileges. Part 2 of this series reviewed DB2's sequence, distinct type, function, procedure, routine, collection, package, and plan privileges. In this article, we conclude our discussion of DB2 object privileges by examining the remaining privileges available to control user interactions with DB2 objects.