Consultor Eletrônico

Status: Verified

SYMPTOM(s):

Error 7574 trying to create a table using SQL-92

No RESOURCE privileges (7574)

SQL Explorer returns error when attempting to execute CREATE TABLE statement:

SQLState=HY000
ErrorCode=-20057
[JDBC Progress Driver]:No RESOURCE privileges (7574)

FACT(s) (Environment):

Not using a DBA or sysprogress user
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
OpenEdge Category: SQL

CAUSE:

To create a table you must have RESOURCE privilege.

RESOURCE privilege granted the privilege to issue CREATE statements, therefore add objects, such as tables, to the database.

FIX:

Create or grant RESOURCES privilege to a user and then run CREATE TABLE statement using this user following the steps:

1) Using SQL explorer or other preferred SQL tool, connect the database using a sysprogress user or the current DBA of the database.
2) Use GRANT statement to set RESOURCE privilege to a user.

This is the syntax to GRANT database-wide privileges:

SYNTAX

GRANT { RESOURCE, DBA } TO username [ , username ] , ... ;

EXAMPLE:

CREATE USER 'dbuser1','1234';
GRANT RESOURCE TO dbuser1;
COMMIT;

note: this user must be created using CREATE USER statement not via Data Dictionary.

3) Disconnect the database and reconnect now using the user and run CREATE TABLE statement.