LAN account, or HR could notify needed parties at same time, access to bldg, Active directory and so forth. -- Joel Patterson Sr. Database Administrator | Enterprise Integration Phone: 904-928-2790 | Fax: 904-733-4916 http://www.entint.com/ http://www.entint.com/ http://www.facebook.com/pages/Enterprise-Integration/212351215444231 http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah http://www.youtube.com/user/ValueofIT This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1] From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Herring, David Sent: Wednesday, April 09, 2014 1:27 PM To: JBECKSTROM@xxxxxxxxx; oracle-l-freelists; oracle-db-l Subject: RE: maintenance / review of Oracle database accounts We use a ticketing system and all account requests need to be approved by the requestor's manager and the DBA manager. The auditing piece is a problem for us as we don't get notified when someone leaves, so we rarely know if a given account is still needed. I would prefer some sort of notification to be sent out when a person's LAN account is being removed. Dave Herring From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom Sent: Wednesday, April 09, 2014 7:00 AM To: oracle-l-freelists; oracle-db-l Subject: maintenance / review of Oracle database accounts Just wondering what members of the community do to keep track of end user access requests for access to the database. Do you really on paper forms for requesting access or what? Do you audit the requests to determine if the individual is still employed and / or access is still required and on what frequency is the review done? Who has to approve the access requests? Please respond offline. Jeffrey Beckstrom Database Administrator Information Systems Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 . -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l