Hello,

We are running Informix 11.50.FC6 and we have a daily process done by
a user which truncates the table owned by user "informix" and loads
the table with new data. We need to allow the user to update stats
after the load. The user cannot update stats because they are not the
owner of the table. Aside from creating an SP owned by informix which
update stats in the SP and gives permissions for the user to execute,
is there any other way to allow the user to update stats on the table?

--Dave

The only other option would be to GRANT DBA privileges to this user. A DBA
procedure to update the statistics that this user has privilege to run is
probably the best option.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Tue, Dec 28, 2010 at 10:03 AM, Dave <in4mixdba (AT) gmail (DOT) com> wrote:

Art,

Thank you. I will use the update stats via the SP solution.

Have a great day,

--Dave

On Dec 28, 10:38*am, Art Kagel <art.ka... (AT) gmail (DOT) com> wrote: