Checking access authorization for data definition statements

Db2 checks for the necessary authorization privileges and authorities when you use data definition statements on certain Db2 objects.

DB2® determines whether the authorization ID that you are using has the necessary privileges to access the following objects:

• Alias
• Table
• Explicitly created auxiliary table
• Explicitly created table space
• Explicitly created index
• Storage group
• Database

At run time, Db2 determines whether the authorization ID that you are using has the necessary privileges to access the following objects:

• Buffer pool that is involved with an implicitly created table space
• Buffer pool and storage group that are involved with an implicitly created auxiliary index and LOB table space
• Buffer pool and storage group that are involved with implicitly created XML indexes and XML table space
• Trigger
• Function
• Procedure
• Sequence
• View
• Trusted context
• JAR
• Role
• Distinct type
• Table, buffer pool, and storage group for an implicitly created unique key index, primary key index, or ROWID index.