Subject Re: [firebird-support] Problem desactivate index FB2.1
Author Helen Borrie
At 12:56 AM 19/06/2008, you wrote:
>Hello,
>
>My application have to do a lot of insert. I find that it win a lot of
>time if i desactivate the indexes. However my application is not
>connected to the firebird database with the owner and when the sql
>code "ALTER INDEX I_ENREGISTREMENTS_NOM_SITE INACTIVE" is executed the
>application return this error message : "unsuccessful metadata update
>MODIFY RDB$INDICES failed no permission for control access to TABLE
>ENREGISTREMENTS"
>
>
>Is there is a way to desactivate index on a table when the user that is
>connected to the firebird database is not the owner?

Only the owner of the TABLE or the sysdba can do this.

./heLen