[EHPweb] Fwd: Database Access

[Eric Martinez]

All,
	Attached is a spreadsheet identifying all the current user accounts  
on our database on ehpmaster.  I have combed through this list and  
cross-referenced with what you all have told me thus far with what I  
know in general and what I've seen in the access logs.  Please review  
the list of actions to be taken; pay close attention to the accounts  
that will be deleted.  It is much easier to delete an account than to  
get it working again.  I will start working down this list starting at  
13:00 MST today.  Since time is a factor, please call me with any  
changes you feel need to be made to this list. 720.570.6303.

Thanks,
	~Eric.



Begin forwarded message:

> From: Eric Martinez <emartinez at usgs.gov>
> Date: October 23, 2008 9:54:03 AM MDT
> To: EHPweb <ehpweb at geohazards.usgs.gov>
> Subject: Fwd: Database Access
>
> All,
> 	Below is a short list of users that have accessed our database in  
> the passed two days.  Most of these accesses are acceptable, however  
> I have marked four of these accounts for removal because no one  
> seems to know what they are doing.   If any of these accounts marked  
> below for removal are doing something useful that you are aware of  
> please let me know ASAP of they will be deleted.  Please note this  
> is a list only of accounts that are actively accessing our  
> database.  A full list of accounts to be deleted will be sent out  
> later today.
>
> +----------+-----------------------------+-------------+
> | user     | host                        | Action      |
> +----------+-----------------------------+-------------+
> | ehprepl  | ehp1.cr.usgs.gov            |             |
> | ehprepl  | ehp3.gps.caltech.edu        |             |
> | ehprepl  | ehp4.cr.usgs.gov            |             |
> | ehprepl  | ehpbackup.cr.usgs.gov       |             |
> | ehprepl  | ehpdevel.cr.usgs.gov        |             |
> | ehprepl  | gldsvrbuild1.cr.usgs.gov    |             |
> | hmind    | localhost                   |             |
> | lisa     | igskcicgltlwald.cr.usgs.gov |             |
> | netops   | gldqc.cr.usgs.gov           |             |
> | quake    | localhost                   |             |
> | root     | localhost                   |             |
> | shaefner | jayhawk.wr.usgs.gov         |             |
> | web      | ehpmaster.wr.usgs.gov       |             |
> | web      | ehzeast.er.usgs.gov         | DELETE      |
> | web      | ehzmenlo.wr.usgs.gov        | DELETE      |
> | web      | ehznorth.wr.usgs.gov        | DELETE      |
> | web      | localhost                   |             |
> | webwrite | ehp1.cr.usgs.gov            |             |
> | webwrite | ehp2.wr.usgs.gov            |             |
> | webwrite | ehp3.gps.caltech.edu        |             |
> | webwrite | ehp4.cr.usgs.gov            |             |
> | webwrite | ehpmaster.wr.usgs.gov       |             |
> | webwrite | nsmprt1.wr.usgs.gov         | DELETE      |
> +----------+-----------------------------+-------------+
>
> Remember I will be deleting accounts at 13:00 MST today, so please  
> respond ASAP to avoid headaches.
>
> Thanks,
> 	~Eric.
>
>
>
> Begin forwarded message:
>
>> From: Eric Martinez <emartinez at usgs.gov>
>> Date: October 22, 2008 10:50:44 AM MDT
>> To: EHPweb <ehpweb at geohazards.usgs.gov>
>> Subject: Database Access
>>
>> All -
>> 	Some accounts that we were fairly certain could be deleted have  
>> been.  If you are accessing the database on ehpmaster (or any other  
>> web server) from ANY server using ANY username, please let me  
>> know.  You can reply by filling in the blanks below:
>>
>> I use the _________ user to access the database on the machine  
>> ________ from the machine ________.  It is used for the ________  
>> process.
>>
>> Let me know about accounts even if you think it is a very common  
>> account and safe from being deleting.  Any account that I am not  
>> explicitly told about will be deleted tomorrow at 13:00 MST.  If  
>> you think anybody who might need to know about this and is not on  
>> this mailing list, please forward it ASAP.  If you know of anybody  
>> who might need to know about this and is on leave right now, please  
>> reply to me so I can accommodate.
>>
>> Below is a list of accounts that have recently accessed our  
>> database on ehpmaster.  Please let me know if you think any of  
>> these accounts are performing old actions that are no longer needed  
>> and could be deleted.
>>
>> ehprepl at ehp1.cr.usgs.gov
>> ehprepl at ehp2.wr.usgs.gov
>> ehprepl at ehp3.gps.caltech.edu
>> ehprepl at ehp4.cr.usgs.gov
>> ehprepl at ehpbackup.cr.usgs.gov
>> ehprepl at ehpdevel.cr.usgs.gov
>> ehprepl at gldsvrbuild1.cr.usgs.gov
>> hmind at localhost
>> lisa at igskcicgltlwald.cr.usgs.gov
>> quake at localhost
>> root at localhost
>> shaefner at jayhawk.wr.usgs.gov
>> web at ehpmaster.wr.usgs.gov
>> web at ehzeast.er.usgs.gov
>> web at ehzmenlo.wr.usgs.gov
>> web at ehznorth.wr.usgs.gov
>> web at localhost
>> webwrite at ehp1.cr.usgs.gov
>> webwrite at ehp2.wr.usgs.gov
>> webwrite at ehp3.gps.caltech.edu
>> webwrite at ehp4.cr.usgs.gov
>> webwrite at ehpmaster.wr.usgs.gov
>> webwrite at nsmprt1.wr.usgs.gov
>>
>> Thanks,
>> 	~Eric.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://geohazards.usgs.gov/pipermail/ehpweb/attachments/20081023/f2ecb62e/attachment-0002.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: dbusers.xls
Type: application/octet-stream
Size: 14336 bytes
Desc: not available
Url : http://geohazards.usgs.gov/pipermail/ehpweb/attachments/20081023/f2ecb62e/attachment-0001.obj 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://geohazards.usgs.gov/pipermail/ehpweb/attachments/20081023/f2ecb62e/attachment-0003.html