All Forums General
larun1616 29 posts Joined 09/14
30 Oct 2014
COLLECT STATS ACCESS

Hi
     When i try to execute the below statement inside a Stored Procedure as below i get an error as stated:
CALL DBC.SYSEXECSQL ('COLLECT STATISTICS ON DBNAME.Table_Name  INDEX (Column1);');  
ERROR:
The user does not have STATISTICS access to DBNAME.Table_Name.
 
Please help me with the command to grandt access to the user.
 
Regards
Arun

krishaneesh 140 posts Joined 04/13
30 Oct 2014

GRANT STATISTICS ON dbname.tablename TO username

Raja_KT 1246 posts Joined 07/09
30 Oct 2014

Grant statistics is introduced from 13.0.Before 13.0,a user must have had “Index” or “Drop” privileges at the table level to be able to collect statis­tics.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.