Chapter 10
A1: | DB2 relies on operating system security and does not store user IDs and passwords in the database. |
A2: | DB2 also supports Kerberos security service. Starting with DB2 Version 8.2, you can also write your own security service as plug-in. The plug-in will be loaded at instance startup. |
A3: | When a new package is bound to the database, for example, when creating an SQL stored procedure, BINDADD is required. |
A4: | He must have CONNECT privileges to connect to the database and CREATETAB privileges to create a new table in the database. Because he is trying to create a table that has a different schema than the authorization ID (i.e., bob), he must have IMPLICIT_SCHEMA privileges if schema mary does not already exist. If it does exist, then ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.