Solved

quick report error

Userlevel 3

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?

icon

Best answer by alpamuk 31 January 2023, 09:10

Userlevel 1

Hello @Norahmf ,

You must Grant your created view on database.

For example

GRANT select on ifsadmin.xxxv_your_view_name TO ifsadmin

commit;

Userlevel 3

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

Userlevel 1

Could you to this please grant for all your user;

GRANT select on your_view_name TO public;

Then do not forget!

commit;

Userlevel 3

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

Sign up