>> 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.

Hm, no, that's not an option.
A user should be able to start a stored procedure after an import with some more data.

It's only a user who mustn't be admin.


Thank you.


Björn


--
Björn Reimer - RRZE