Subject | Re: [firebird-support] Problem desactivate index FB2.1 |
---|---|
Author | Helen Borrie |
Post date | 2008-06-18T21:43:28Z |
At 12:56 AM 19/06/2008, you wrote:
./heLen
>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
>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?
./heLen