Chris and Justin, Thanks for the helpful tips! Much appreciated!
All the best, Melissa Melissa Ceraso Evergreen Systems Manager Bibliomation, Inc. 24 Wooster Ave. Waterbury, CT 06708 203-577-4070 ext. 116 On Wed, Mar 16, 2016 at 12:31 PM, Justin Hopkins 📖 < [email protected]> wrote: > Melissa, > > You might try running the command by hand (the exact command you have > in cron) with the user who's crontab it is in. That user may not have > the same environment or database permissions as your user on the > system where it's working. > > Justin > > On Wed, Mar 16, 2016 at 11:20 AM, Melissa Ceraso <[email protected]> > wrote: > > Hello, > > > > We altered a Wowbrary SQL script to fix a few errors that were occurring > for > > some of our Wowbrary subscribers. The amended script runs fine on our > > database server. Yet, since it has been applied to our utility server to > run > > as a cron job, we are consistently receiving the following error message: > > > > 53: ERROR: permission denied for relation record_sorter > > > > At this point, we cannot figure out why the script runs fine on the > > database, but fails during the cron job. Any thoughts, ideas or even a > lead > > as to where I should start investigating further would be greatly > > appreciated! Also, if further information is needed, I can certainly > provide > > more. > > > > All the best, > > > > Melissa > > > > Melissa Ceraso > > Evergreen Systems Manager > > Bibliomation, Inc. > > 24 Wooster Ave. > > Waterbury, CT 06708 > > 203-577-4070 ext. 116 > > > > -- > Regards, > Justin >
