Print Page | Close Window

Seeing Views in my data connection

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19773
Printed Date: 20 Apr 2025 at 6:47am


Topic: Seeing Views in my data connection
Posted By: bremen
Subject: Seeing Views in my data connection
Date Posted: 16 Jul 2013 at 5:32am
There are several views that are in my oracle databse, but I am unable to see them while using the database expert to see the avialable tables. 
 
I do have the option checked to see views in the options section, but I am still unable to see them. 
 
I am uising CR 2011 
 
 


Replies:
Posted By: lockwelle
Date Posted: 19 Jul 2013 at 5:23am
You might already have solved this, and I don't really know oracle, but this recently happened to me with some stored procs in SQL Server...
The user that I connected to the database with did not have permission to see the stored procs. I had to grant EXECUTE permission to the stored proc, and then I could see them in CR.

HTH


Print Page | Close Window