Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Seattle
    Posts
    8

    Unanswered: No create index permission

    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!

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: No create index permission

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •