Re: crystal reports dll and oracle

Two things to try:
select * from owner.tablename
or
grant select permission to user on the table (or to a role you grant to the user) and then either use the above syntax or create a synonym (public or private) for the table.

DBAs typically have the 'Select Any Table' privilege, which would be why the user can see the table when they are DBA.

amos_at_cvidya.com (amos) wrote in message news:<39801319.0410182328.14e1ea15_at_posting.google.com>...
> 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 - 09:29:06 CDT