Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Seeing Views in my data connection Post Reply Post New Topic
Author Message
bremen
Groupie
Groupie
Avatar

Joined: 28 May 2013
Online Status: Offline
Posts: 93
Quote bremen Replybullet Topic: Seeing Views in my data connection
    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 
 
 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.