DBADM
The DBADM authority includes the DBCTRL privileges over a specific database. A user with the DBADM authority can access any tables in a specific database by using SQL statements.
With the DBADM authority, you can also perform the
following actions:
- Drop or alter any table space, table, or index in the database
- Issue a COMMENT, LABEL, or LOCK TABLE statement for any table in the database
- Issue a COMMENT statement for any index in the database
If the value of the DBADM CREATE AUTH field on the DSNTIPP installation panel is set to YES during the Db2 installation, an ID with the DBADM authority can create the following objects:
- A view for another ID. The view must be based on at least one table, and that table must be in the database under DBADM authority.
- An alias for another ID on any table in the database.
An ID with DBADM authority on one database can create a view on tables and views in that database and other databases only if the ID has all the privileges that are required to create the view. For example, an ID with DBADM authority cannot create a view on a view that is owned by another ID.
If a user has the DBADM authority
with the GRANT option, that user can grant these privileges to others.