Hi I am having trouble updating the index selectivity with regular users. When I run the code:

EXECUTE BLOCK AS
declare variable index_name VARCHAR(31);
BEGIN
for select RDB$INDEX_NAME from RDB$INDICES into :index_name do
execute statement 'SET statistics INDEX ' || :index_name || ';';
END!!


I receive the error:
MODIFY RDB$INDICES failed
no permission for control access to TABLE RDB$RELATIONS
At procedure 'Index_Selectivity' line: 10, col: 3

If I run the same code under sydba it works fine.
So I am wondering how can I give the user the access he needs to run this code.

Armen

NOTE: User has all access with grant option on all tables and procedure, but that does not seem to be enough to update System Tables