PM77006: SQLCODE -551 WHEN GRANTING SELECT TO TABLE THAT IS CREATED IN IMPLICITLY CREATED DATABASE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • sqlcode -551 when granting select to table that is created in
    implicitly created databse
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL DB2 10 and 9 for z/OS users.             *
    ****************************************************************
    * PROBLEM DESCRIPTION: SQLCODE551 received when a user with    *
    *                      DBADM authority with grant option on    *
    *                      DSNDB04 tried to grant select privilege *
    *                      on a table in an implicit database.     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    SQLCODE551 was received when a user with DBADM authority with
    grant option on DSNDB04 tried to grant select privilege on a
    table that he created for another user in an implicit database.
    
    SQLCODE551 can also be received while using DBADM authority
    with grant option on DSNDB04 for granting other table
    privileges on a table in an implicit database.
    
    Authorization did not take into consideration the grantor
    having DBADM authority with grant option on DSNDB04 during the
    grants on a table in an implicit database.
    

Problem conclusion

  • DB2 code is changed to allow a user with DBADM on DSNDB04
    with grant option to be able to perform grants in the above
    stated scenarios.
    
    Additional keywords: DBADM SQLCODE551 GRANT
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM77006

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-13

  • Closed date

    2013-04-05

  • Last modified date

    2013-05-03

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

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

    UK93187 UK93188

Modules/Macros

  •    DSNXA2TM
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK93187

       UP13/04/20 P F304

  • R910 PSY UK93188

       UP13/04/20 P F304

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM77006

Modified date:

2013-05-03

Translate my page

Machine Translation

Content navigation