Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: crystal reports dll and oracle

Re: crystal reports dll and oracle

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 19 Oct 2004 08:43:14 -0500
Message-ID: <1098193326.QJfrj8X2GKvVvBG3ygOFYA@teranews>

As I replied to your cross-post

Use a fully-qualified table name, i.e. Select * from schema.tablename, not just tablename.

amos_at_cvidya.com (amos) wrote:

>thank you for your comments.
>
>im using oracle 9i.
>and i have a simple: select * from tablename.
>
>ofcourse that one of the solutions we have here is to not make this
>user a DBA, or make ONLY this user a DBA. but it sounds like a
>workaround.
>
>if it is a feature, i hope someone will know to explain me why this
>feature is for :)
>
>when making the report it generate the sql automaticaly and we run it
>as batch (when i run the same report directly from CR, it works fine)
>
>thanks again for your help
>
>joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0410181538.6bb8ead0_at_posting.google.com>...
>> amos_at_cvidya.com (amos) wrote in message news:<39801319.0410180030.78fee63e_at_posting.google.com>...
>> > hi
>> >
>> > i have installed crystal reports and im using its activex import in
>> > delphi in order to create a report.
>> >
>> > i have a connectionstring which connects to a certain database with a
>> > certain user_id.
>> >
>> > the problem is as follow:
>> > 1) if the user has no dba rights, everything is ok.
>> > 2) if the user has DBA rights, the data comes from the first user's
>> > schema (alphabetically ordered) which is a DBA and has the table from
>> > which we do the "select".
>> >
>> > i have never seen such a behavior and have no explanation how this can
>> > be.
>> >
>> > anyone has ideas?
>> >
>> > thanks
>>
>> Sounds like it is doing a select from the first table it sees in the
>> all_tables view.
>>
>> If you can attach with sqlplus as these users, try this command:
>>
>> select table_name, owner from all_tables where upper(table_name) =
>> 'YOURTABLENAMEINCAPS' order by owner;
>>
>> If that doesn't work, substitute dba_tables for all_tables.
>>
>> This is an oracle feature, which could be a CR feature, too, if CR
>> handles it reasonably. The caps stuff is ordinarily not needed, but
>> may be screwed with by non-oracle tools if they make lower or mixed
>> case tablenames.
>>
>> You probably shouldn't be giving DBA access to tools for non-DBA
>> purposes.
>>
>> You can also use OEM (among others) to see what CR is passing to
>> oracle.
>>
>> jg
Received on Tue Oct 19 2004 - 08:43:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US