joe_echavarria
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.
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.
USER_A likely needs to be granted access to those objects in the Dev database.
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.
I will use "Oracle Server" to connect using crystal report - works on any version 2008 and 2013.
ASKER
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.