Skip to main content

I create a quick report from view created in database 

but when try to order report I faced this issue 

I need urgent help please.

is there any missing step or something?

Hello @Norahmf ,

 

You must Grant your created view on database.

 

For example 

 

GRANT  select on  ifsadmin.xxxv_your_view_name TO ifsadmin

commit;

thanks for answer ,I granted just now as you said but still same issue must wait sometime or need  another step?

Could you to this please grant for all your user;

 

GRANT select on your_view_name TO public;

 

Then do not forget!

 

commit;

Thank you very much .. you saved me today..!!!👏

Reply


Terms & ConditionsCookie settings