I am trying to use an end user log in in order to create custom SQL reports using Oracle SQL Developer. Currently the user permission does not allow me to access any of the views or APIs for reference. What permission is necessary to view the tables and APIs?
Best answer by KEVSER
View originalhi mmoss,
you can solve the problem by writing “ifsapp.” at the beginning of the tables and api in sql reports.
for exp
ifsapp.inventory_part_api.Get_Description
ifsapp.inventory_part_tab
+22
Hi
in pl sql developer you can do the following steps:
But you can’t show a table. It works only with IFSAPP.
The IAL-user, most probably named IFSINFO, has read only access to tables.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
