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".
Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<1098193175.Fap80SwQL5W+/fbF0nM7Vg_at_teranews>...
> 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 Wed Oct 20 2004 - 04:22:05 CDT
