20 pts.
0
Q:
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!
ASKED: Nov 24 2008  8:52 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
1165 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Nov 26 2008  0:36 AM GMT by Slack400   1165 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Emy   70 pts.  |   Dec 4 2008  1:58AM GMT

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.

 
0