The database administrator has assured me that there is an EUL setup
for this account. The guy that is able to access the database using
Discoverer is using version 3.1.26. I have version 3.1.36.06. Is it
possible that my version of Discoverer is incompatible with EULs setup
for version 3.1.26?
Martin Doherty <martin.doherty_at_oorraaccllee.com> wrote in message news:<CF9J9.17$e14.120_at_news.oracle.com>...
> Larry,
>
> It sounds like you have been making successful queries directly against
> the base data tables via Access & Perl. However, when using Discoverer
> the EUL (End User Layer) is a mandatory setup component that forms a
> meta-layer of data between you and the base data tables. It's a kind of
> "data dictionary" that Discoverer uses, and if it is not set up then
> Discoverer can do nothing. For example, you can create "folders" of
> "items" which roughly correspond to tables and columns, but if the
> folder is not defined in the EUL then Discoverer cannot access the
> underlying table. The EUL allows the Disoverer administrator to present
> queryable data to non-technical business users in a more
> self-explanatory, intuitive fashion than if they were trying to access
> the data tables directly. A folder can be defined that joins the
> columns of multiple tables, each column is given a friendly name, and
> the table join is invisible to the end user.
>
> You need to contact the Discoverer administrator for your site, or if
> YOU are he, then you'll need to do some serious research into the
> concepts, setup and operation of this tool.
>
> Martin Doherty
>
> Larry wrote:
>
> >Dear Friends:
> >
> >I have legal access to a remote database. I have been able to
> >establish a connection using ODBC and MS Access, with the appropriate
> >username, passowrd, and TNS file. I have been able to do the same
> >using a perl script. However, I have been unable to do the same with
> >Discoverer. Version 4 says something about EULs needing to be
> >upgraded and version 3.1 says that there are no EULs available...
> >However, there are plenty of tables that I have been able to gain
> >access to using MS Access and perl script. My problem is that the
> >database owner wants to restrict me to using Discoverer to access the
> >database.
> >
> >Any ideas on what might be keeping me from connecting using
> >Discoverer?
> >
> >Thanks,
> >
> >Larry
> >
> >
Received on Tue Dec 10 2002 - 15:01:42 CST
