JR62612: DOC - THE GRANT SQL FOR A NON-DBA USER TO ATTAIN IBM DB2 DATABASE PRIVILEGES IS INCORRECT

APAR status

• Closed as documentation error.

Error description

• In "Db2 database privileges"
  (https://www.ibm.com/support/knowledgecenter/SS8JB4_20.x/com.ibm
  .wbpm.imuc.doc/topics/rpln_db_privileges_db2.html), the create
  @SEQUENCE_NAME@ to user @DB_USER@; line should be deleted from
  the following section:
  
  "It is generally not recommended to grant DBADM authority to a
  non-DBA user. Instead, you can use the following syntax to grant
  the appropriate privileges to a non-DBA user without actually
  granting direct DBADM authority:"
  
  db2 list tables for schema @DB_USER@
  grant select, update, delete, insert on @TABLE_NAME@ to user
  @DB_USER@;
  grant references on @TABLE_NAME@ to user @DB_USER@;
  create @SEQUENCE_NAME@ to user @DB_USER@;
  grant usage on sequence @SEQUENCE_NAME@ to user @DB_USER@;
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• The content will be updated the next time the documentation is
  refreshed.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels