Re: Where's your DBA access level?

From: pSeries AIX Geek (aixgeek_at_YAHOO.COM)
Date: 09/11/04

  • Next message: john.dundas_at_IFF.COM: "John Dundas/UB/US/NA/IFF is out of the office." 
    Date:         Sat, 11 Sep 2004 09:52:57 -0700
To: aix-l@Princeton.EDU

    I find that most DBAs are more cautious than
    sysadmins, and even if they have root access, rarely
    use it except for things they need.

    For low-key production systems on down, I have no
    problem letting know it's there [actually, I just
    grant them full sudo rights and let them tell me when
    they want them scaled back.]

    The risk that they might do something dumb is
    mitigated by the time it saves me.

    - pAG

    --- Bob.Kelley@BRINKSINC.COM wrote:

    > How many of you guys out in industry give your DBAs
    > unix level access to
    > your servers? In production? Development? I don't
    > recommend giving login
    > access to database administrators regardless of unix
    > experience for several
    > reasons.
    >
    > Oracle, for example, has several tools with which
    > you can administer Oracle
    > itself, almost negating the need for a unix login
    > altogether. One of these
    > on the robust/high-end being Enterprise manager, and
    > on the other
    > simple/low-end being the Oracle client.
    >
    > Another issue I consider is server accountability
    > within a given IT
    > organization. How secure have you made your server?
    > Ultimately, to
    > executives outside IT, who gets the black eye if
    > there is a configuration
    > issue, or the common accidental file deletion or
    > typo? Is it the individual
    > DBA? The DBA group? Or, is it most likely going to
    > be the infrastructure
    > group responsible for the server and its
    > availability overall? When you
    > take yourself out of the comfort zone of your IT
    > knowledge, I think in most
    > companies, its going to be the latter.
    >
    > Can I log/connect in to DB2? Yes, I most certainly
    > know how. Can I do a
    > table query? Of course I can. Am I certified? Does
    > the DBA responsible for
    > that server want me to do these things? No, they
    > don't and for very good
    > reason. Tiered access...that's not really the point
    > here.
    >
    > Bobby Kelley Jr.
    > 972-877-5341
    >

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

  • Next message: john.dundas_at_IFF.COM: "John Dundas/UB/US/NA/IFF is out of the office."

    Relevant Pages

    • Re: Wheres your DBA access level?
      ... I onced worked at .com where I was unix admin, dba, ... Most dba's need unix login access. ... Another issue I consider is server accountability within a given IT ...
      (AIX-L)
    • Wheres your DBA access level?
      ... How many of you guys out in industry give your DBAs unix level access to ... I don't recommend giving login ... Another issue I consider is server accountability within a given IT ... The DBA group? ...
      (AIX-L)
    • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
      ... someone else's server for testing some SELECT statements I'm writing for them. ... How do I get a free Oracle client installed, if possible, so I can test some SQL statements. ... There is no documentation with that download. ... Only a DBA should be ...
      (comp.databases.oracle.tools)
    • Re: Wheres your DBA access level?
      ... Where's your DBA access level? ... How many of you guys out in industry give your DBAs unix level access to ... Another issue I consider is server accountability within a given IT ...
      (AIX-L)
    • Re: command line vs grid control
      ... Oracle from SQL Server, Sybase, or Informix OEM gives them instant ... What it does in that chapter they already do very simply and cheaply and so does any dba that has been on the job for a while. ... And Vista has set Microsoft ...
      (comp.databases.oracle.server)