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.

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.

Any suggestions as to what the problem might really be, please? There
is no sign of any other database-related problem at the site.

TIA


--
Five Cats
Email to: cats_spam at uk2 dot net

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/

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