Solved

Language_sys.Set_Language permission

  • 27 October 2022
  • 2 replies
  • 228 views
KamuranCanakli
Rank
Userlevel 2
Badge +5

Hello,

I use IFS9 API on SQL Developer. One user get error ORA-20106 Language.NoAccess for Set_Language. How can I set this authority

 
icon

Best answer by Charana Udugama 27 October 2022, 18:53

View original

2 replies

Charana Udugama
Rank
Userlevel 7
Badge +10

Hi @KamuranCanakli,

Check the permission sets that were granted to your specific user. Get them loaded in the below window.

Then see which permission sets it has been granted and whether the users have been granted with the permission set residing under “IFS Base Functionality > FndSession > FND_SESSION_API > Set_Language”

If the user doesn’t have that, grant it. Refresh Security Cache and see if that user has access or not. 

 

Best Regards,

Charana

https://lk.linkedin.com/in/charanau
kavinduxo
Rank
Userlevel 3
Badge +8

Hello,

I use IFS9 API on SQL Developer. One user get error ORA-20106 Language.NoAccess for Set_Language. How can I set this authority

 

Hi @KamuranCanakli ,

If you are using database scripting tool like plsql developer just try to run the following code snippets in command window. It may solve your issue. This is more like clearing the cache in you application in navigator path → refresh cache

   
DEFINE GRANTEE = IFSSYS
PROMPT Granting to &GRANTEE
BEGIN


   Installation_SYS.Grant_Ifssys(TRUE);
END;
/
UNDEFINE GRANTEE
-- [SQL_COMMAND GRANT_TO_FND_PRINTSERVER]
DEFINE GRANTEE = FND_PRINTSERVER


PROMPT Granting to &GRANTEE
BEGIN
   Installation_SYS.Grant_Fndprintserver(TRUE);
END;
/
UNDEFINE GRANTEE
DEFINE GRANTEE = FND_WEBCONFIG
PROMPT Granting to &GRANTEE
BEGIN
   Installation_SYS.Grant_Ifswebconfig(TRUE);
END;
/
UNDEFINE GRANTEE
-- [SQL_COMMAND GRANT_TO_IAL_OWNER]
DEFINE GRANTEE = IFSINFO


PROMPT Granting to &GRANTEE
BEGIN
   Database_SYS.Grant_All_Objects_Ial('&GRANTEE');
END;
/
UNDEFINE GRANTEE


PROMPT Refreshing Dictionary_SYS
EXEC Dictionary_SYS.Rebuild_Dictionary_Storage_(1, 'COMPUTE');


PROMPT Refreshing Reference_SYS
EXEC Reference_SYS.Refresh_Active_List__(2);


PROMPT Reinitialize packages


-- This command disables Installation_Mode in Dictionary_SYS
EXEC Dbms_Session.Modify_Package_State(Dbms_Session.Reinitialize);
/
PROMPT Refreshing Security_SYS
EXEC Security_SYS.Refresh_Active_List__(3);
/
PROMPT Refreshing Report_SYS
EXEC Report_SYS.Refresh_Active_List__(4);

 

Thanks,

Kavindu

Reply


Terms & ConditionsCookie settings