Skip to main content
Solved

Refreshing Security Cache

  • Aug 3, 2022 8:39 AM UTC
  • 3 replies
  • 308 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;

View original

3 replies

Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • Answer
  • Aug 3, 2022 9:48 AM UTC

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

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


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • Aug 3, 2022 11:07 AM UTC

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