+6
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 ?
Best answer by william.klotz
View original
+21
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
+6
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?
+6
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
+6
Solved
+21
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.