Page 1 of 1
Can IA see views (versus physical tables)?
Posted: Wed Oct 20, 2010 1:16 am
by truenorth
We created views of tables but when I try to import metadata, the views are not available. Is IA only able to work on physical tables only?
Posted: Wed Oct 20, 2010 2:48 am
by ray.wurlod
There should be no problems with views. Have you granted SELECT privilege to the view for the IA user?
Posted: Wed Oct 20, 2010 4:14 pm
by tcj
I can confirm that IA can see views.
Posted: Sun Oct 31, 2010 3:56 pm
by truenorth
Thanks, guys.
The DBA had checked and confirmed we have SELECT permission on the views. But IA still could not see them.
RESOLVED: In Set Pre-filter, I had to Include Views, which is off by default.