Troubleshooting
Problem
A user with SECADM or ACCESSCTRL authority receives an error when granting the following privileges
- EXECUTE privilege on SYSIBMADM.UTL_DIR module
- CREATE_EXTERNAL_ROUTINE privilege on the database
- CREATE_NOT_FENCED_ROUTINE privilege on the database
Examples of the errors are:
db2 => grant create_external_routine on database to user dba
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0552N "BOSS" does not have the privilege to perform operation "GRANT".
SQLSTATE=42502
db2 => grant execute on module sysibmadm.utl_dir to user dba
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0551N The statement failed because the authorization ID does not have the
required authorization or privilege to perform the operation. Authorization
ID: "BOSS". Operation: "GRANT". Object: "SYSIBMADM.UTL_DIR". SQLSTATE=42501
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PlOAAU","label":"Security and Plug-Ins-\u003EAuthorization and Privilege"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
ibm16523848