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!
November 24, 2008 8:52 PM
December 4, 2008 1:58 AM