>>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
|