Granting and Revoking DB2 authority

20 pts.
Tags:
DB2 administration
DBA
IBM DB2
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!

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Emy
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following