Subject | Permission for SET STATISTICS |
---|---|
Author | Björn Reimer |
Post date | 2012-10-10T18:51:56Z |
Hello,
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
Björn
--
Björn Reimer - RRZE
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
Björn
--
Björn Reimer - RRZE