In this blog post, let’s learn about the error message “388 No resource permission.” in Hydra and the description of the error.
Error Message
388 No resource permission.
Error Details
If you issued a CREATE TABLE, CREATE INDEX, or CREATE PROCEDURE statement, you cannot execute this statement because your account has not been granted the RESOURCE privilege for this database. You need the RESOURCE privilege to create permanent tables, indexes on permanent tables, and procedures.
If you issued a SET statement, START VIOLATIONS TABLE statement, or STOP VIOLATIONS TABLE statement, you cannot execute this statement because your account has not been granted the RESOURCE privilege for this database. You need the RESOURCE privilege to execute the SET statement for a constraint, trigger, or index defined on a table in the current database. You also need the RESOURCE privilege to execute the START VIOLATIONS TABLE or STOP VIOLATIONS TABLE statement on a base table in the current database.
To recover from this error, contact a person who has the DBA privilege on this database and ask to be granted the RESOURCE privilege for the database.
No resource permission.
If you issued a CREATE DATABASE statement in an 8.32 database server, you cannot execute this statement because you are not in the group specified in the ONCONFIG file parameter DBCREATE_GRP.
To be included in the operating system group specified in DBCREATE_GRP, see your system administrator.