Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  grant lost

    Posted 09/19/24 07:59 AM

    we have a db2 install 11.5.7 and needed to restore the db after logical error

    all was ok - bu now we get

    Long Message:
    DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098,SQLERRMC=2;-551;42501;RPTUSER|SELECT| INSTTXDW.TAKS_SOURCE_RECORDS_2009, DRIVER=3.50.152

    if we check in sysibm.systabauth the grant is still present - also when running db2look -x we see the grant needed

    to resolve the problem we executed the grant again and now the problem is not present anymore

    is it possible that grants get de-activated/invalid after restore to same db ?  never seen this problem before



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------


  • 2.  RE: grant lost

    Posted 09/19/24 02:20 PM

    Did you GRANT SELECT ... after you backed up database?

    If so - after restore grant is rightfully lost.



    ------------------------------
    Jan Nelken
    ------------------------------



  • 3.  RE: grant lost

    Posted 09/20/24 03:10 AM

    of course not...  before the backup

    and the grant is available in ...auth table   but not active



    ------------------------------
    Thanks for all answers
    Best Regards,
    Guy Przytula
    ------------------------------

    Original Message


  • 4.  RE: grant lost

    Posted 09/20/24 04:17 AM
    Edited by Jan Nelken 09/20/24 05:21 AM

    Any changes in groups, group membership between last backup and restore?

    It appears to be an interesting puzzle - is it recreatable in test environment?



    ------------------------------
    Jan Nelken
    ------------------------------

    Original Message


Related Content