Tired of tracking down all the users in the database to deactivate
them when they cease to exist, or change roles, or fulfill their
temporary need to the database? Or, tracking down privileges you
granted to existing users at the end of their requested period? The
solution is to think out of the box - developing a system that
allows you to create a database user account with an expiration
date. This fire-and-forget method allows you to create users
with the assurance that they will be expired (locked or dropped) at
the expiration date automatically, without your
intervention. Interested? Read on how I developed such a system--along with source code for you to try.
Confessions of an Oracle Database Junkie - Arup Nanda The opinions expressed here are mine and mine alone. They may not necessarily reflect that of my employers and customers - both past or present. The comments left by the reviewers are theirs alone and may not reflect my opinion whether implied or not. None of the advice is warranted to be free of errors and ommision. Please use at your own risk and after thorough testing in your environment.
Showing posts with label Autoexpiration. Show all posts
Showing posts with label Autoexpiration. Show all posts
Subscribe to:
Posts (Atom)