20 pts.
 Granting and Revoking DB2 authority
We've had several requests to grant 'temporary' SELECT authority on a table (meaning they want the user to have the authority for today, and not tomorrow). The DBAs don't want the housework of remembering to revoke the authority tomorrow, so we were wondering if anyone knows a way to grant authority either with an expiration or something similar? Thanks for any ideas you can give me!

Software/Hardware used:
ASKED: November 24, 2008  8:52 PM
UPDATED: December 4, 2008  1:58 AM

Answer Wiki:
You could schedule a job to cleanup the authority. As for expiration I don't think there's such a thing. You could set them up with an alternate profile. You could set an expiration on the User ID to disable or delete after a specific date and time. If you need assistance with the scheduled job option let us know what platform you're running on. DB2 I want to assume it's AS400 but I'm not sure by your question's tags.
Last Wiki Answer Submitted:  November 26, 2008  12:36 am  by  slack400   2,680 pts.
All Answer Wiki Contributors:  slack400   2,680 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

There realy aren’t any specific DB2 command by which you can revoke a database grant in DB2.
So you’ll need either to schedule a REVOKE job every time you want to revoke any grant automatically or to create a program specific to this need.

 70 pts.