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?
Solved
How to view tables or packages without IFSAPP
Best answer by KEVSER
hi 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
hi 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
+23 Hi
in pl sql developer you can do the following steps:
But you can’t show a table. It works only with IFSAPP.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.