Link to home
Start Free TrialLog in
Avatar of joe_echavarria
joe_echavarriaFlag for Dominican Republic

asked on

Oracle and Crystal Report / can not see database USERS/SCHEMAS

Hi,

   I am not able to see one user's tables and views when using crystal report.      

   When browsing Data Explorer->My connections->DatabasePROD can see the schema tables and views of an specific user (USER_A) , but when Data Explorer->My connections->DatabaseDEV i am not able to see that user (USER_A) neither the tables and views.   The same thing happens with others users like SYSMAN, SYSTEM,etc.

  This happens with version 2008 , but with version 2013 i can see the users but not its views.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

USER_A likely needs to be granted access to those objects in the Dev database.
Avatar of joe_echavarria

ASKER

When I use ODBC (RDO) to connect - no VIEWs  but when I use "Oracle Server" to connect - FINE.

 I will use "Oracle Server" to connect using crystal report - works on any version 2008 and 2013.
The user in both databases have the same setting.
>>when I use "Oracle Server" to connect

I'm not a Crystal Reports person and I do not know what "Oracle Server" means.  If that is something specific to Crystal, then you'll have to wait for a Crystal Expert.

If it something related specifically to Oracle and the database, I might be able to help but would need to know what it is.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial