Re: crystal reports dll and oracle

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 - 02:28:12 CDT