Error accessing DB2 Z/OS tables OR when creating a Cross Connection Query Builder:
ERRORS:
ERROR [42501] [IBM][DB2] SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "<user or schema>". Operation: "SELECT". Object: "SYSIBM.SYSSCHEMAAUTH".
OR
IBM.Data.DB2.DB2Exception: ERROR [42501] [IBM][DB2] SQL0551N "040861" does not have the required authorization or privilege to perform operation "SELECT" on object "SYSIBM.SYSTABLES". SQLSTATE=42501
Stack trace:
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
at IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()"
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center