IBM Db2 11.1 Certification Guide

The data load (LOAD) authority

Users with LOAD authority are allowed to perform the following tasks:

• Quiesce or query the state of a table space
• Perform bulk-load operations by using the LOAD command
• Collect catalog statistics by using the RUNSTATS command

You can assign LOAD authority on a database called SAMPLE to user john by executing the following statement:

CONNECT TO sample; 
GRANT LOAD ON DATABASE TO USER john;

If you want to revoke LOAD authority on a database called SAMPLE from user john, execute the following statement:

CONNECT TO sample; 
REVOKE LOAD ON DATABASE FROM USER john;