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,