Re: MINUS Query Problem

Any user who can access the tables involved should be able to use the MINUS operator and get a result..Check to see if the users who do not seem to be able to do it have any resource restrictions ( perhaps a non-default profile or a limited role ) ; also check the code they are using...perhaps it's just a bad sql issue...

David Ward <dpcs9dw_at_nospam.gov.calgary.ab.ca> wrote:

>Hi,
>
>I am having a strange problem with a MINUS query under Oracle 8.1.5.
>
>Some users are able to execute the MINUS query and return the expected
>rows, while others do not get a response (ie. the query is executed
>under SQL*Plus and SQL*Plus just seems to stop responding). The users
>who do not get a response can successfully return the expected rows from
>each part of the MINUS query.
>
>I realize that I have not provided much background information here, and
>at first I thought it might be a security-related problem. It just seems
>strange that a user who can retrieve the expected rows from each part of
>the MINUS query cannot retrieve any rows from the full MINUS query.
>
>Any ideas on this?
>
>Thanks,
>
>Dave
Received on Tue Dec 05 2000 - 08:53:03 CST