Skip to main content

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? 

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 

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.

Reply


Terms & ConditionsCookie settings