RE: maintenance / review of Oracle database accounts

  • From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
  • To: "HerringD@xxxxxxx" <HerringD@xxxxxxx>, "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Wed, 9 Apr 2014 15:00:53 -0400

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


Other related posts: