Before you begin...

To grant privileges on tables or views, you need the proper authorizations:

• To grant privileges on catalog tables and views, you need either SYSADM or DBADM authority.

• To grant privileges on user-defined tables and views, you need to meet the following requirements:

  • To grant the CONTROL privilege on a table or view, you need SYSADM or DBADM authority.

  • To grant table or view privileges other than CONTROL, you need one of these authorizations:

    • SYSADM authority

    • DBADM authority

    • The CONTROL privilege on the tables or views that you want to grant privileges on

    • The privilege you want to grant, along with the Grant option (the right to grant this privilege to other users and to groups)

    Example

    You can grant the ALTER privilege on a user-defined table if you hold one of these authorities:

    • SYSADM authority

    • DBADM authority on the database in which the table resides

    • The CONTROL privilege on the table

    • The ALTER privilege, along with the right to grant the ALTER privilege on this table to other users and to groups

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]