Update Stats not Table Owner
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@iiug.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@gmail.com> wrote: > 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 > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
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...@gmail.com> wrote: > 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 (a...@iiug.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 <in4mix...@gmail.com> wrote: > > 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 > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text -