Skip to main content
Solved

Refreshing Security Cache

  • August 3, 2022
  • 3 replies
  • 280 views

Forum|alt.badge.img+6

Cześć,
Szukam procedury, która odświeży zabezpieczenia z poziomu plsql. Niestety poniższy wpis dodaje lub edytuje wiersz w tabeli cache_management_tab.

BEGIN
    CACHE_MANAGEMENT_API.Refresh_Cache('Security');
END;

 

 

Best answer by maurycy.gawlik

Hi,
I am looking for a procedure that will refresh the plsql security. Unfortunately, the following entry adds or edits a row in the cache_management_tab table.

Begin
     CACHE_MANAGEMENT_API.Refresh_Cache ('Security');
END;

3 replies

Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 11 replies
  • Answer
  • August 3, 2022

Hi,
I am looking for a procedure that will refresh the plsql security. Unfortunately, the following entry adds or edits a row in the cache_management_tab table.

Begin
     CACHE_MANAGEMENT_API.Refresh_Cache ('Security');
END;


Forum|alt.badge.img+21
  • Superhero (Employee)
  • 500 replies
  • August 3, 2022

You can use this: Security_SYS.Refresh_Active_List__(1);


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • 11 replies
  • August 3, 2022

Thank you very much. That was exactly what it was about.