Thank you for your response.
In the case of native security, is that a revoke from any arbitrary
example, doing a GRANT and REVOKE to QWERT will flush all cached
for all users?
On Tue, 15 Aug 2017 12:29:54 +0300 Meir Zohar
<[login to unmask email]> wrote:
:>As with so many things in DB2 - it depends
:>If you're using DB2 security - DB2 will automatically flush
the cache when
:>you revoke an authority.
:>If you're using an external security mechanism (i.e. RACF), a
:>eventually get to the cache (however you can GRANT/REVOKE the
:>DB2 will process a request again the next time you attempt to
:>If you're on DB2 V11 or upward and the AUTHEXIT_CACHEREFRESH
:>parameter is set to ALL, DB2 listens to type 62, type 71, and
type 79 ENF
:>signals from RACF® for any user profile or resource access
changes. If DB2
:>receives ENF 62, 71, and 79 signals, it refreshes the cache
entries of the
:>package authorization, the routine authorization, the DDF
:>authentication, and the dynamic statement.
:>Meir Zohar, CISSP
:>dbX Consulting Services
:>IBM Gold Consultant
:>IBM Champion for Analytics
:>IBM Certified Database Administrator DB2 for z/OS
:>IBM Certified Database Administrator DB2 for LUW
:>IBM Certified Specialist - PureData System for Analytics
:>Israel DB2 RUG
:>IDUG GMC & EMEA 2017 CPC
:>Tel: +972 3 5747860
:>Fsx: +972 3 5747864
:>Mob: +972 54 5747350
:>Email: [login to unmask email] – [login to unmask email]
:>מאת: Binyamin Dissen [mailto:[login to unmask email]
:>נשלח: Tuesday, August 15, 2017 12:07
:>אל: [login to unmask email]
:>נושא: [DB2-L] - How can I flush/clear
the DB2 security cache?
:>Is there a command that clears/flushes the DB2 security cache,
so that it
:>needs to reread the information? Not seeing the obvious
Binyamin Dissen <[login to unmask email]>
Director, Dissen Software, Bar & Grill - Israel
Should you use the mailblocks package and expect a response from
you should preauthorize the dissensoftware.com domain.
I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.