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.

At both bind and run time, 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.