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


   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.
joe_echavarriaDatabase AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
USER_A likely needs to be granted access to those objects in the Dev database.
joe_echavarriaDatabase AdministratorAuthor Commented:
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.
joe_echavarriaDatabase AdministratorAuthor Commented:
The user in both databases have the same setting.
slightwv (䄆 Netminder) Commented:
>>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.
For the ODBC are you using a 32 or 64-bit connection.  Even the latest version of Crystal is strictly 32-bit so you need to create as 32-bit ODBC connection.

I work with 2 reporting tools and generally have to create both 32 and 64-bit connections to the data source to ensure both tools work.  They have to be named the same.

I don't know what Oracle Server is either.  I don't have it in my Crystal install.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.