> which permissions needs a user for executing the SQL command
>
> set statistics index "<Index-Name>";
>
> The user is not owner of the table.
>
>
> Giving him GRANT ALL TO<table> ... is not enough:
>
> This operation is not defined for system tables.
> unsuccessful metadata update.
> MODIFY RDB$INDICES failed.
> no permission for control access to TABLE KDS.
>
> I'm using FB 2.5.2.26508

There is no fine-grained security object for SET STATISTICS available.
Normally, the following users can run SET STATISTICS:

- SYSDBA
- Owner of the database
- Owner of the table

You could also play with the pre-defined RDB$ADMIN role.


Regards,
Thomas