>>informix 님께서 쓰시길<<

:: -388

::

:: __________________________________________________________

::

:: No resource permission.

::

:: If you issued a CREATE TABLE, CREATE INDEX, or CREATE PROCEDURE statement, you cannot execute th

:: is statement because your account has not been granted RESOURCE privilege in this database. You

:: need the RESOURCE privilege to create permanent tables, indexes on permanent tables, and procedu

:: res.

::

:: If you issued a SET statement, START VIOLATIONS TABLE statement, or STOP VIOLATIONS TABLE statem

:: ent, you cannot execute this statement because your account has not been granted RESOURCE privil

:: ege in this database. You need the RESOURCE privilege to execute the SET statement for a constra

:: int, trigger, or index defined on a table in the current database. You also need the RESOURCE pr

:: ivilege 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 on the database.

퍼미션을... user한테 주면 되는뎅..

informix 유저로 로긴해서 - informix는 informix user가 super-user지요.

권한이 필요한 Database를 선택하고

grant dba to "필요한user"

그럼 그넘도 DBA권한 생김니당.

필요한 DB_NAME : db_name

필요한 user : db_user

예)

$ su - informix

$ cat > grant.sql

grant dba to "db_user";

^D

$ dbaccess db_name grant