Re: crystal reports dll and oracle

the thing is crystal builds the select statements itself, i have no control over it. but i do see the owner.table when doing menu->database->show sql query

i must add:
i had "administrator", "dbo", "myuser" as DBA's. 1st run: it took data from "administrator"'s table. (first alphabetically dba)
i just deleted this user's schema and ran again. i got no errors and no nothing, but it simply took the data from "dbo" user.
i had another schema "aaa", i gave it DBA rights, and ran again. again, no errors no nothing, and it simply took the data from "aaa".

mpir_at_bellsouth.net (Joe Maloney) wrote in message news:<d17bad25.0410190629.60dc4144_at_posting.google.com>...
> 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 Thu Oct 21 2004 - 03:17:12 CDT