Skip to main content

Hello.

I would like to view the definitiion of an IAL but I can’t find it, not even via SQL developer, what’s the way the view the definition of an IAL?

For example, I would like to view the SQL querry used to define this IAL :

 


Hi @romsar 

in IEE it isn’t available. You find it in PLSQL developer.

Example: IFSINFO.MY_IAL

Note: permissions are required for IALs

 


@link I was sure it was possible to view their definitions via SQL developer, but I have a weird behavior. 

When I filter the views list with SFD_LO_HR_012_IAL, the list is empty, but if I do a right click on SFD_LO_HR_012_IAL in the querry builder, click on “open declaration”, I can find it this way.

 

 

is that the only way to view the query? I’m connected to the database by using the IFSAPP user


In SQL Developer, if you are logged in as the Application Owner, you will see a selection called “Other Users”

 

Expand this, find IFSINFO, and expand the “Views” area, search for the IAL you need, and click on the SQL tab - that may get you what you are looking for.


Thanks @MWitczak that’s exactly what I needed


Reply