Db2

 View Only

  • 1.  New Schema Authorities?

    Posted Wed March 31, 2021 12:24 PM

    Hi,

     

    there are new columns in catalog view SYSCAT.SCHEMAAUTH

    DB2v111 "SYSCAT  ","SCHEMAAUTH","SELECTINAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","INSERTINAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","UPDATEINAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","DELETEINAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","EXECUTEINAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","SCHEMAADMAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","ACCESSCTRLAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","DATAACCESSAUTH","CHARACTER",1,0,"N"
    DB2v111 "SYSCAT  ","SCHEMAAUTH","LOADAUTH","CHARACTER",1,0,"N"

    So I assume that V11.1 supports grants for SELECT, INSERT, UPDATE, DELETE, EXECUTE, ..

    And I tried GRANT SELECT ON SCHEMA TPC TO USER GERHARD and ran in this error

    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0557N  The specified combination of privileges cannot be granted or
    revoked.  SQLSTATE=42852
    [db2inst2@lxdb205 ~]$

    So please provide further information to these columns and the affected syntax diagram.

    Thanks!

    Best regards,

    Gerhard Paulus


    #Db2
    #Db2EarlyAccessProgram(EAP)Forum


  • 2.  RE: New Schema Authorities?
    Best Answer

    Posted Wed March 31, 2021 12:25 PM

    Hi Gerhard,

     

    These catalogs are being introduced in DB2 11.1 as part of the foundation for a planned future enhancement and are reserved for future use. This new capability is not part of the function DB2 11.1 GA and is not committed yet to DB2 11.1...  but you are guessing in the right area and we have very high hopes of being able to tell you more about it later in 2016.

     

    Hope this answers your question,

     

    Paul Bird.


    Original Message


  • 3.  RE: New Schema Authorities?

    Posted Wed March 31, 2021 12:25 PM

    Hi Paul,

     

    thanks. Good to know there maybe will come these schema authorities in future maybe V11.1 Fixpacks or VNext.

    Thanks!

     

    Best regards,

    Gerhard


    Original Message