|
Problem IC69777
|
Status: Closed |
Using system defined modules result in SQL0551N "SYSIBM RATOR" does not have the required authorization or privilege |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
This symptom can be made if the database is created with
username of which length is greater than 8 characters such as
ADMINISTRATOR and the system defined module is executed.
If you see a SQL0551N error with "SYSIBM RATOR", you are
impacted by this issue.
For example, while executing, module UTL_FILE fails with
error below.
SQL0551N "SYSIBM RATOR" does not have the required
authorization or privilege to perform operation "EXECUTE" on
object "SYSIBMADM.Pxxxxxxx". SQLSTATE=42501
If you see the "Definer length : 13" and "Definer : SYSIBM
RATOR" in the output of the following db2cat, then you have the
issue on that database.
> db2cat -d <dbname> -s SYSIBMADM -n imp_fopen -m UTL_FILE
-p routine -o imp_fopen.pd.fmt
> find /i "definer" imp_fopen.pd.fmt
---------- IMP_FOPEN.PD.FMT
Definer length : 13
Definer : SYSIBM RATOR
Definer type : S |
| Problem Summary: |
|
| Local Fix: |
Re-create the database with a user whose username length is
<=8 characters. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Comment |
This APAR is a duplicate of IC65070 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.07.2010
13.07.2010
13.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
