Can you tell me how we can grant a custom made IAL to user IFSSYS?
We find in the documentation the following text.
Own views need to be granted to user IFSPRINT and IFSSYS
We are able to grant the custom made IAL’s to IFSPRINT (via IFS application – Security – Permission Sets) but we don’t see the IFSSYS user here.
Maybe we have to this in PL/SQL ?
Hi
You can use sqlplus to perform the grant.
GRANT SELECT ON 'view_name' to 'user_name';
Replace the ‘view_name’ with your IAL name and replace ‘user_name’ with IFSSYS.
William
Hi William
Thanks for your response. This is the first time I use sql plus. After startup i get this screen, but i dont know which username/passwd i need to type here.
Can you help me?
Hi William
i tried it also in PL/SQL Developer but it does not work.
the IAL is definitely in this environment so it must exist there.
Do you have a great idea to solved this
Solved
Hi
Sorry I didn't see your follow-up question until now but looks like you've got it.
In IFS the IAL's are owned by IFSINFO instead of IFSAPP.
Regards,
William
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.