IV34644: ORACLE TRUNCATE AUTHORITY CANNOT BE SCOPED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • On Oracle, to truncate a table or cluster, the table or cluster
    must be in your schema or you must have DROP ANY TABLE system
    privilege.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All TBSM Users                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * On Oracle, to truncate a table or cluster, the table or      *
    * cluster must be in your schema or you must have DROP ANY     *
    * TABLE system privilege.  Drop any table privilege gives the  *
    * user authority to truncate any table within the schema.      *
    * While TBSM only reads from other TADDM tables, this could be *
    * viewed as a violation of their security policy .             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The solution is to allow the customer to create the table    *
    * tbsm_change_history_table in the user's schema.              *
    ****************************************************************
    None
    

Problem conclusion

  • This schema would be the default schema for the TADDM database
    user used by TBSM to access the TADDM database.  This will grant
    that user truncate authority to this table, but not to the other
    tables in the TADDM database.   This database user would still
    need read access to the schema containing the other TADDM
    tables.
    
    A new property has been added to the toolkit properties file:
    DL_TADDM_DBManager.Schema_TCHT
    The fix for this APAR is contained in the following
    maintenance packages:
    |Interim Fix | 6.1.0.1-TIV-BSM-IF0003
    |Fix Pack | 6.1.0-TIV-BSM-FP0002
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV34644

  • Reported component name

    TIV BUS SERV MG

  • Reported component ID

    5724C5100

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-15

  • Closed date

    2013-01-18

  • Last modified date

    2013-02-14

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

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

Modules/Macros

  • UNKNOWN
    

Fix information

  • Fixed component name

    TIV BUS SERV MG

  • Fixed component ID

    5724C5100

Applicable component levels

  • R610 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Business Service Manager

Software version:

610

Reference #:

IV34644

Modified date:

2013-02-14

Translate my page

Machine Translation

Content navigation