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

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.