Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
grant control on table, to run runstats via sp, not working in V9.5.0.7
34 views
Skip to first unread message
ultra...@gmail.com
Apr 25, 2013, 11:00:08 AM4/25/13
to
Have a stored procedure that runs the following
CALL SYSPROC.ADMIN_CMD ('RUNSTATS ON TABLE SDBXXX.TABLENAME with distribution and detailed indexes all')
Granting control to the user works.
When control is granted via the role this does not work.
SQL2311N The user does not have the authority to run the Run Statistics
utility on table "SDBXXXX.TABLENAME ".
Any suggestions?
Thank you.
CALL SYSPROC.ADMIN_CMD ('RUNSTATS ON TABLE SDBXXX.TABLENAME with distribution and detailed indexes all')
Granting control to the user works.
When control is granted via the role this does not work.
SQL2311N The user does not have the authority to run the Run Statistics
utility on table "SDBXXXX.TABLENAME ".
Any suggestions?
Thank you.
Message has been deleted
0 new messages