RE: Strange problem with 'drop synonym'

How about changing your code to switch your session to that of the owner, before you drop it ? Set session authorization to "owner" Drop & recreate ...... It could also be the table that you are pointing to, and not the synonym itself ... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Five Cats Sent: Friday, February 06, 2004 7:35 PM To: informix-list@iiug.org Subject: Re: Strange problem with 'drop synonym' In message <c7QUb.16801$uM2.3374@newsread1.news.pas.earthlink.net>, Jonathan Leffler <jleffler@earthlink.net> writes >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. That was my point. They appear to own the synonym but can't drop it. > >> 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... > -- Five Cats Email to: cats_spam at uk2 dot net ________________________________ << ella for Spam Control >> has removed 1247 Spam messages and set aside 228 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list sending to informix-list