Skip to main content
Solved

quick report error

  • January 31, 2023
  • 4 replies
  • 117 views

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 56 replies

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?

Best answer by alpamuk

Could you to this please grant for all your user;

 

GRANT select on your_view_name TO public;

 

Then do not forget!

 

commit;

View original
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+7
  • Sidekick
  • 11 replies
  • January 31, 2023

Hello @Norahmf ,

 

You must Grant your created view on database.

 

For example 

 

GRANT  select on  ifsadmin.xxxv_your_view_name TO ifsadmin

commit;


Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 56 replies
  • January 31, 2023

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


Forum|alt.badge.img+7
  • Sidekick
  • 11 replies
  • Answer
  • January 31, 2023

Could you to this please grant for all your user;

 

GRANT select on your_view_name TO public;

 

Then do not forget!

 

commit;


Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 56 replies
  • January 31, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings