|Re: [firebird-support] Problem desactivate index FB2.1
At 12:56 AM 19/06/2008, you wrote:
>Hello,Only the owner of the TABLE or the sysdba can do this.
>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
>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?