2074342 - Cannot drop a user that owns tables in runtime system - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2074342 - Cannot drop a user that owns tables in runtime system - SAP IQ

Symptom

  • The iqunload utility with -au (Schema Unload Mode) option aborted with an error.
  • The SQL error:

***** SQL error: Cannot drop a user that owns tables in runtime system

This file contains the statement that caused the schema reload failure.
To complete the schema reload, you need to modify your database to avoid generating the statement below.
Once you have modified your database appropriately, re-run the schema reload process.
NOTE: You may want to generate the schema only for the database being reloaded,
and load this schema into an empty database to check for sql errors.

REVOKE CONNECT FROM rs_systabgroup


Read more...

Environment

SAP IQ 12.7 (Multiplex Environment).

Product

Sybase IQ 12.7

Keywords

rs_systabgroup,  runtime system , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.