Skip to Content
0
Former Member
Jul 15, 2015 at 05:16 PM

Access privileges on user defined views (views under scheme)

16 Views

Hi,

I have created one user defined view under my schema using the below code.

Create view myschema.myview as

select current_date as today from dummy.

I can able to execute the select query from my login but from other login I am getting insufficient privilege error.

I have given catalog_read system privilege to the user.

What is the issue in my code? Please someone help me to solve the error.

Thanks & Regards,

Ranjith.