Re: Strange problem with 'drop synonym'

Five Cats wrote: > I have a customer running IDS 7.31.UD4 on Solaris. They have a program > which is run from a script every night, and part of what it does is drop > & recreate a synonym. > > All of a sudden it won't do that (getting the error that says the user > doesn't own it). The synonym was dropped before running the program by > another user which fixed it for that run, but then the problem came back. > > They have Resource access to the DB (I checked it myself!) which they > have always had, and the synonym (according to systables.owner) is owned > by the correct user. A RESOURCE level user can create their own tables and synonyms, but cannot manipulate other people's tables and synonyms unless given explicit permission to do so - GRANT ALTER etc. Off-hand, I'd say that you cannot drop someone else's synonym unless you are a DBA. > I've suggested they up the access level to DBA to see if that helps, but > of course they shouldn't have to do that. Depends on the owner... > Any suggestions as to what the problem might really be, please? There > is no sign of any other database-related problem at the site. Ownership... -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/