amos_at_cvidya.com (amos) wrote:
>i did publish this question on a delphi newsgroup but it looks like a
>dead newsgroup.
>
>the version i wrote: 9i
>the connection string is: PROVIDER=ORAOLEDB.ORACLE;;DATA
>SOURCE=DT_SRC;;USER ID=USER_NAME;;PASSWORD=BLAH;;LOCALE
>IDENTIFIER=1037;;OLE DB SERVICES=-5]
>
>if USER_NAME as DBA rights, it goes to the first DBA user schema
>(alphabetically) which has the certain table and takes the data from
>there.
>if USER_NAME is not a DBA then everything is ok.
>
>amos_at_cvidya.com (amos) wrote in message news:<39801319.0410180020.3757de54_at_posting.google.com>...
>> DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1098065020.441618_at_yasure>...
>> > amos wrote:
>> >
>> > > 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
>> >
>> > What does this have to do with Oracle?
>> > And if it does ... what version?
>> >
>> > You should be asking this question at Business Objects Crystal Tech Support.
>>
>> the answer is easy, as i said the problem occurs in oracle (9i) and in
>> sqlserver for example, it doesnt happen. i thought mayb someone else
>> has encountered this problem as well.
The simple answer is to use the fully-qualified table name, i.e. schema.table_name , instead of just the table name..
Received on Tue Oct 19 2004 - 08:40:42 CDT
