Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Configuring Authorities, Privileges, and Permissions

Configuring Authorities, Privileges, and Permissions

IBM DB2 privileges allow you to create or access database resources. Authority levels allow you to group privileges and perform higher-level database manager maintenance and utility operations. Together, these act to control access to the database manager and its database objects. You can access objects for which you have the required privilege or authority.
To load data into a table, you must have one of the following authorities:
  • SYSADM authority
  • DBADM authority
  • LOAD authority on the database and one of the following privileges:
    • INSERT privilege on the table when the load utility is invoked in insert, terminate, or restart mode.
    • INSERT and DELETE privilege on the table when the load utility is invoked in replace, terminate, or restart mode.
In addition, you must have proper read access and read/write permissions:
  • The database instance owner must have read access to the external loader input files.
  • If you run IBM DB2 as a service on Windows, you must configure the service start account with a user account that has read/write permissions to use LAN resources, including drives, directories, and files.
  • If you load to IBM DB2 EEE, the database instance owner must have write access to the load dump file and the load temporary file.


Updated June 03, 2019