Re: crystal reports dll and oracle

 Remove any public synonyms that may refer to any of the tables in all the schemas. There is no way Crystal can access anything but the exact schema.tablename specified in the Sql statement.

amos_at_cvidya.com (amos) wrote:

>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 - 09:09:21 CDT