Showing results for 
Search instead for 
Did you mean: 

Cv View is not giving any result when created as SQL Analytic Privilege

0 Kudos


I have created a cv view with Analytic Privilege option selected as 'SQL Analytic Privilege'. And i have not assigned this CV to any Analytic Privilege i.e. SQL.

When i try to query the CV View , i am getting Insufficient Privilege Error.

The Same cv view when i create with Classic Analytic Privilege option and query the view without assigning it to Analytic Privilege i.e. Classical, i can view the data.

I want to know the reason of why it is working like this.

Thank You,

Raviteja Purama

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

For XML your user more than likely has the role _SYS_BI_CP_ALL which would allow you to view the data.

Active Participant
0 Kudos

Hi Raviteja,

Go to catalog --> _SYS_BIC --> Column Views --> Right click on your view --> Show Authorization and see what it tells.On hovering over the red lines, you will come to know what is missing from authorisation stand point.