Authorization checking for implicitly created databases
RACF access control module checks only for authorization to DSNDB04. It does not check for authorization to the implicitly created database.
On Db2 V8, if you create a table and do not specify a database name, Db2 creates the table in the default database, DSNDB04. With Db2 V9, Db2 creates a database for you with the name DSNxxxxx, where xxxxx is a zero-padded increasing integer, and creates the table space or table in that database. The value of xxxxx wraps to 00001 after the limit for the number of implicitly created databases is reached. As a result, tables created by different users might be placed in the same implicitly created database.
Db2 allows access to an implicitly created database if the user has authorization to either DSNDB04 or the implicitly created database. The RACF access control module differs from Db2 in that it checks only for authorization to DSNDB04. It does not check for authorization to the implicitly created database.