Kbase 19045: Error 7883 trying to create objects in the SYSPROGRESS schema from a SQL-92 client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2010 |
|
Status: Verified
SYMPTOM(s):
Error 7883 trying to create objects in the SYSPROGRESS schema from a SQL-92 client
SQLState=3F003
ErrorCode=-211015
Database object (table, view, index, trigger, procedure, or synonym) owned by "sysprogress" cannot be created, dropped or altered (7883)
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
OpenEdge Category: SQL
CAUSE:
It is not possible to create objects in the SYSPROGRESS schema.
The SYSPROGRESS schema is the System Catalog. It is a set of system tables for storing information about tables, columns, indexes, constraints, and privileges. All users have read access to these tables, but no user has any access to modify this information directly. These tables can only be modified by SQL DDL (Data Definition Commands) statements, or by GRANT and REVOKE statements.
If logged in as SYSPROGRESS, or if the schema is set to SYSPROGRESS, the (7883) error will appear if attempting to create any objects without giving them a schema.
For example, if the schema is set to SYSPROGRESS, try to execute the following SQL DDL:
create table tab1 (col1 numeric(3,2));
Error 7883 will appear.
This applies to all objects, including tables, indexes, stored procedures etc.
FIX:
Choose one of the following:
1) set the schema to a different schema, using the "SET SCHEMA" statement.
2) assign the schema within the statement:
example: create table schema1.tab1 (col1 numeric(3,2));
By default, users other than SYSPROGRESS will not have their default schema set to SYSPROGRESS. The SYSPROGRESS user (if available) will have SYSPROGRESS as the default schema.