RE: Monitoring DB Admin



Hello,
First of course it is doable.

You have the primary account restricted. Have half a password setup and
used by 2 people if you are really paranoid. When I worked to get
Lasseter's Casino accepted by the Government as an online casino, they
where noticeably paranoid as this was the first time (worldwide) that a
Casino was licensed over the Internet. The NT Government official had
half the password, the CIO at Lasseter's the other half.

All actions used SUDO to lock down and log all actions that the admin
took. The rare occasions that needed the console root where tightly
controlled and recorded.

This stated this was difficult and costly. Very costly! A Casino can
afford this, but your execs may wish to check the cost benefits.

On the other hand, logging and monitoring is your friend. The "COPS II"
system a number of years back was configured with the monitoring aim of
ensuring that police using the system could get any data they need, but
that IA could crack down on "unusual access". This was the "looking up a
mate's ex bit" for instance. In this all access was logged and sent to a
BI (Business Intelligence) system, basically data mining.

I would NEVER want admin without my actions being logged to death. I
have learned the hard way. As admin you are blamed for all things that
can not be pinned on another. As security admin things are worse. Logs
are your friend. They prove that you did not do it. This may not be
ideal, but when several million go missing from the books and
investigators start looking to find a scapegoat, the logs are your best
mate.

If you think that not logging your own actions is a good thing, than you
are either fooling yourself or need more time in the industry. Trust me,
when it hits the fan, being able to prove yourself innocent is a
godsend. This may not be ideal or even "right", but it is prudent.

Regards,
Craig



Craig Wright
Manager of Information Systems

Direct : +61 2 9286 5497
Craig.Wright@xxxxxxxxxx
+61 417 683 914

BDO Kendalls (NSW)
Level 19, 2 Market Street Sydney NSW 2000
GPO BOX 2551 Sydney NSW 2001
Fax +61 2 9993 9497
www.bdo.com.au

Liability limited by a scheme approved under Professional Standards Legislation in respect of matters arising within those States and Territories of Australia where such legislation exists.

The information in this email and any attachments is confidential. If you are not the named addressee you must not read, print, copy, distribute, or use in any way this transmission or any information it contains. If you have received this message in error, please notify the sender by return email, destroy all copies and delete it from your system.

Any views expressed in this message are those of the individual sender and not necessarily endorsed by BDO Kendalls. You may not rely on this message as advice unless subsequently confirmed by fax or letter signed by a Partner or Director of BDO Kendalls. It is your responsibility to scan this communication and any files attached for computer viruses and other defects. BDO Kendalls does not accept liability for any loss or damage however caused which may result from this communication or any files attached. A full version of the BDO Kendalls disclaimer, and our Privacy statement, can be found on the BDO Kendalls website at http://www.bdo.com.au or by emailing administrator@xxxxxxxxxxx

BDO Kendalls is a national association of separate partnerships and entities.

-----Original Message-----

From: listbounce@xxxxxxxxxxxxxxxxx [mailto:listbounce@xxxxxxxxxxxxxxxxx]
On Behalf Of WALI
Sent: Tuesday, 29 May 2007 1:31 PM
To: security-basics@xxxxxxxxxxxxxxxxx
Subject: Monitoring DB Admin

....And the auditors report mentions that I (the internal IT Security
Admin) should have independent monitoring of DB Admin activities, the
likes
of DROP, ALTERS etc on an inhouse developed accounting package using
Oracle
9i backened.

Not only this, the crazy auditing guys want to have preventive rather
than
detective controls in place for DB Admin.

How secure can we make an application if we start doubting the guys we
trust...the next thing the auditors would want is preventive controls
over
me...Grrr!!

But still...is this doable!!??



Relevant Pages

  • Re: account trapping
    ... Our monitoring application has to run as Admin to ... > query the server registrys. ... Is there an easy way to setup an account with Admin ... PGP / XML GATEWAY APPLIANCE ...
    (Security-Basics)
  • Re: Bypass School And Work Filters www.classgetter.com
    ... I have seen connections from. ... It took me under a minute to find software I (as an admin) could install on users PCs to monitor all of the URLs visited and even tools that allow monitoring page content. ... These tools integrate in to the browser and monitor the browser rather than the network connection, so they are monitoring before outbound data is encrypted and after inbound data in decrypted, so it matters not whether the browsing is through an encrypted tunnel. ...
    (comp.security.firewalls)
  • Re: Admin rights
    ... If you try to limit what an admin account can do you only end ... a plain user account to do the monitoring?? ... I have some users that need to use RDP to get on to a server to monitor ...
    (microsoft.public.windows.server.security)
  • RE: Monitoring DB Admin
    ... If you have more then one DB Admin; ask yourself if they all need the ... What the auditors want to see are tools in place to limit the damage any ... Subject: Monitoring DB Admin ... trust...the next thing the auditors would want is preventive controls ...
    (Security-Basics)
  • Re: Relocating /Users
    ... Randy Howard wrote: ... Maybe I'm paranoid, but I'd do the last part this way: ... It just creates a new home dir in /Users for the admin. ... You won't have any of the stuff available from your home dir but you can log in and start doing restore/maintenance. ...
    (comp.sys.mac.system)