By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Tracking Revokes

P: n/a
Does a revoke post an entry in the DB2 catalog that would allow an
query of the number of revokes by someone? Or does the revoke just
delete the grant and leave no record in the catlalog? I am on DB2 V8
for Z/OS.

Feb 23 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Huskerdoo wrote:
Does a revoke post an entry in the DB2 catalog that would allow an
query of the number of revokes by someone? Or does the revoke just
delete the grant and leave no record in the catlalog? I am on DB2 V8
for Z/OS.
It wouldn't be in the catalogs. Check out DB2 zOS's _auditing_ capabilities.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Feb 23 '07 #2

P: n/a
Huskerdoo wrote:
Does a revoke post an entry in the DB2 catalog that would allow an
query of the number of revokes by someone? Or does the revoke just
delete the grant and leave no record in the catlalog? I am on DB2 V8
for Z/OS.
A revoke just removes the entry in the catalog. Unless you are using an
event monitor (not sure if it is available on DB2 for z/OS) or some other
audit facility, I don't think you have access to details on when a revoke
happened.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 23 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.