January 2005
Beginner to intermediate
928 pages
22h 14m
English
| 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 ... |
Read now
Unlock full access