Subject | Problem desactivate index FB2.1 |
---|---|
Author | calou_3324 |
Post date | 2008-06-18T14:56:42Z |
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?
Thank you for help
Regards
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?
Thank you for help
Regards