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

View Entire Topic
0 Kudos

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