Home Server

Missing tables for a user with select rights

edited March 2009 in Server
When I try to run my server side as an Oracle user granted select rights
on a set of tables the report server doesn't see the tables. I get an
oracle error ORA-00942. When logged in as the table owner I see the set
of tables and everything works as expected.

What do I need to modify so the user granted select rights can access
the tables through RB Server?

RB Server 10 DOA Connection to Oracle 9.2 using Delphi 6 SP2


  • edited March 2009
    You can see this in the session explorer.

    Login as the table owner and the tables are there.

    Login as the user granted Oracle select, insert, update and delete
    rights and the tables are not there.

  • edited March 2009
    Check out the TdaDOASession.GetTableNames method in daDOA.pas.

    That method contains the SQL to retrieve the list of tables from the Oracle.
    You might need to modify the SQL to better suit your needs. (I am not an
    Oracle expert, so not sure what SQL you would need, I bet the DOA folks
    would konw).

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.