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.

Begin general-use programming interface information.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. End general-use programming interface information.