Re: Not seeing full list of tables

Hi Frank,


Yes - the user has the appropriate permissions. The user I am using is
"APPS" which has permission to the whole Schema. If I use TOAD - I can see
all the tables in the schema. When I use the ODBC in Access - it shows the
first 'n' tables and rest is not listed. I am not sure whether there is a
limit ('n') in MS Access that will be displayed when connecting to a Oracle
Schema.

What I am trying to find out - Is there a way it can be connected to a table
specifying the table link information instead of the GUI provided in MS
Access?

Worst case scenario I may have to do is to create another user with only
selected table permission for the user to list less tables. I don't want this
approach as the expandablity of the features become difficult.

Regards,
Geo Stan


"Frank Hickman" wrote:

"Geo Stan" <Geo Stan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9677E221-8380-4E2C-9095-D757D0743B6B@xxxxxxxxxxxxxxxx
Hi,

I am trying to connect to Oracle ERP to create a dashboard using MS
Access.
My problem is that when I am trying to link the table with the ODBC
connection - I can see only a certain number of tables in the list and I
cannot see beyond the limit. I want to see whether there is anyway I can
create the table link in the Access database a particular table in the
Oracle
Schema. For eg. apps.gl_balances in Oracle to be directly linked.

Appreciate your advice

Have you verified that the Oracle user you are connecting with has the
appropriate permissions for the table in the schema?

--
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.



.

Relevant Pages

  • Re: Cross-database execution permissions with certificates and sch
    ... around the service broker activated user. ... I agree that this is a good use of schema as a security boundary. ... The comment about schema scoped permissions not being applicable in my ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
    (microsoft.public.sqlserver.security)
  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >Access / Oracle problem, ... >referring to the proper server / SID of every branch. ... >table, when i try to query the second table under another schema, ODBC ... >shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)
  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >>Access / Oracle problem, ... >>referring to the proper server / SID of every branch. ... >>table, when i try to query the second table under another schema, ODBC ... >>shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)
  • Re: Synchronization Wizard weirdness
    ... Using the Oracle Enterprise Manager and Oracle Change Manager packages, ... :> I have a Test Schema in the same database as the Main schema and need to ... Wizard between the Main schema and Test schema -- obviously returned the full ...
    (comp.databases.oracle.tools)
  • Re: Trouble Extending Schema
    ... I can't get the schema extended but I beleive I ... have the permissions set correctly. ... >> I'm trying to find out why it won't let me extend the directory. ... >> correct permission when creating the SMS System Management container. ...
    (microsoft.public.sms.setup)