A custom PL/SQL package's functions aren't all showing up under Database Objects when trying to grant a permission set access to them — some show, others don't, even though they're all in the same package. What's usually missing?

All FAQ questions / Security and access

Answer

Check three things for the functions that don't show up: that the Module_ and Lu_Name_ variables are actually declared with real values in the package spec (not left blank or omitted), that the Dictionary Cache has been refreshed since the package was compiled, and that the IFSSYS role/user has been granted EXECUTE on the package. Any one of these being missing can cause a package's functions to only partially (or inconsistently) appear as grantable in the permission set's Database Objects tab.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions