[SarahBellum]

I am trying to add an index to a table (actually a view of a table) and I am getting the error "No create index permission".

1) I have tried as user root and user informix.
2) I have done the syntax:
grant connect to root;
grant dba to root;
grant resource to root;
3) The owner of the table is a generic name. I have changed the ownership to informix.

None of the above have worked. Help! I know this is something easy that I am just forgetting what I'm doing wrong!

[lloydnwo]

Originally posted by SarahBellum
I am trying to add an index to a table (actually a view of a table) and I am getting the error "No create index permission".

1) I have tried as user root and user informix.
2) I have done the syntax:
grant connect to root;
grant dba to root;
grant resource to root;
3) The owner of the table is a generic name. I have changed the ownership to informix.

None of the above have worked. Help! I know this is something easy that I am just forgetting what I'm doing wrong!

Hi Sarah,

We cannot create an index on a view.

Regards,

Lloyd