Re: crystal reports dll and oracle

From: Joel Garry <joel-garry_at_home.com>
Date: 18 Oct 2004 16:38:15 -0700
Message-ID: <91884734.0410181538.6bb8ead0@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.

--
@home.com is bogus.
http://biz.yahoo.com/ap/041015/oracle_peoplesoft_5.html

Received on Mon Oct 18 2004 - 18:38:15 CDT