I agree.
I have been going through some of my (acquired) databases and revoking
'select any table' privilege from some 'power' users and 3rd party accounts.
Some did not like it and there were many questions as to why all of a sudden
I was doing it. When I explained (and demoed) to them the reasons for that,
and created appropriate roles for their access, they were happy that we (as
a team) addressed and plugged a possible security issue (from auditors'
point of view). Next, I need to educate them again, on the
'remote_os_authent' issues, since we have that too......
We have started a DBA Web page on our intranet. We put out End User Oracle
Tips that include SQL Tuning, CBO/RBO issues, what is listener and how it
works and common TNS related problems etc. Some power users are also given
the CSI numbers to browse Metalink as well, and many are now TechNet
members. The frequency of 'stupid' questions has dramatically reduced.
- Kirti
> -----Original Message-----
> From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Sent: Wednesday, May 17, 2000 4:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle DBA opening in Englewood, CO
>
>
> if an end user is asking that question over and over again, then you
> haven't
> taught him/her well enough. I believe in educating.... not just saying
> "you
> can't do that" and walking away
>
>
> >From: Chris Griffith <Chris.Griffith_at_dstm.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: RE: Oracle DBA opening in Englewood, CO
> >Date: Wed, 17 May 2000 11:56:13 -0800
> >
> >No, I'm one of the senior DBAs that works with a staff of over 70
> >developers. I would rather solve their tuning questions than have an end
> >user ask me over and over how to delete statistics from tables.
> >
> >You are correct, you get some stupid questions, but if you look at the
> >volume of stupid questions there is no comparison.
> >
> >-----Original Message-----
> >Sent: Wednesday, May 17, 2000 1:45 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >Let me guess... you are the only developer in your shop or they all have
> >more experience than you.
> >
> >I have received as many stupid questions from developers as I have from
> end
> >users. And end users do not write code to go against my databases.
> >
> >
> >-----Original Message-----
> ><mailto:Chris.Griffith_at_dstm.com> ]
> >Sent: Wednesday, May 17, 2000 9:29 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I agree. The job of the DBA seems to be everything that everyone else
> >either doesn't want to do or doesn't have the ability to do. We get the
> >wonderful task of figuring out all of the things too hard for everyone
> else
> >to figure out.
> >
> >But, I would much rather support developers than users. Users ask too
> many
> >stupid questions.
> >
> >Chris Griffith
> >OCP DBA
> >
> >-----Original Message-----
> >Sent: Wednesday, May 17, 2000 6:15 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >There seems to be differing views here.
> >
> >I would suggest that this is a very typical jd for many production DBA's.
>
> >I
> >
> >would go on to suggest that many DBA's are in deed jack of all trades
> (and
> >master of some, I would hope). I have been in roles where I sat on my
> DBA
> >throne and dictated to developers on how to optimise their code and I
> have
> >been in roles where I did everything from install and configure hardware
> to
> >wipe users bums. Your typical DBA does what's needed to get the job
> done.
> >
> >And I would take a week supporting uses over a day supporting developers
> >anytime!
> >
> >Phil West - Impex IT ltd
> >Unix Sys Admin and Oracle Financials DBA Services
> >
> >[ all opinions, unless otherwise stated, are personal
> >and subject to change without reason or warning ! ]
> >
> >
> >-----Original Message-----
> >Sent: Tuesday, May 16, 2000 3:40 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >I've been an Oracle DBA for 1.5 years. For the last six months I've
> worked
> >as a Java developer, in addition to supporting Oracle databases (all
> >development). I'm at a crossroads here, trying to decide on a career
> path.
> >Is the job description below pretty typical for DBA work? The idea of
> >providing help desk support and end user support is enough to make me
> >vomit.
> >
> >That is just my personal preference.
> >
> >-----Original Message-----
> >Sent: Monday, May 15, 2000 8:04 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >Currently, Great-West Life has a full-time permanent position available
> in
> >the
> >Financial Services Systems Division working on the Technical
> Infrastructure
> >team
> >(comprised of System Administrators, Database Administrators and System
> >Programmers). This challenging and team-oriented environment supports
> our
> >rapidly growing Financial Services Division.
> >
> >Helping to set long-term technical direction for the division, this
> >individual
> >will be responsible for:
> >
> >7 Providing technical support on UNIX-based distributed computing
> platforms
> >(specifically Sun/Solaris systems) for Oracle RDBMS and related products
> >(e.g.,
> >SQL*Plus, Pro*C, PL/SQL, Developer/2000 specifically Forms 4.5,
> >Designer/2000,
> >Browser).
> >7 Perform 1st and 2nd Tier Help Desk and end-user support. In this
> >capacity,
> >will analyze and resolve technical issues relating to:
> > - In-house applications
> > - 3rd party software
> > - Database performance, capacity, recovery
> > - Hardware and associated peripherals (some)
> >7 The installation and management of Oracle related products.
> >7 Acting as team lead/coordinator of major project initiatives related to
> >the
> >DBA team.
> >7 Document all operations procedures related to team.
> >7 Some on-call time required (no more than 1/4 of year as primary DBA).
> >M
> > ust have previous database administration experience, specifically with
> >Oracle
> >v7.x and v8.x, preferably on Sun Solaris environments. Needs to be able
> >tom
> >
> > ultitask and deal with a high-level of interruptions. Strong
> >interpersonal
> >
> >and
> >communication skills a requirement to succeed in this position. Other
> >desirable
> >experience:
> >
> >7 Sun Servers, Solaris operating system.
> >7 EcoTools, Veritas Volume Manager, Veritas File System, Veritas Quick
> I/O.
> >7 UNIX Tools & Utilities, (C/Bourne/Korn shell, Perl, tar, cpio, etc.),
> >NFS,
> >
> >NIS, TCP/IP.
> >7 Intranet, Internet & Extranet, and WEB server environments.
> >7 Project Management.
> >7 System Security.
> >7 Server Capacity Planning and Performance Tuning.
> >7 X-terminals, Workstations, PCs.
> >7 Multi-threaded server experience.
> >
> >This position requires a degree in Computer Science or Information
> Systems,
> >or
> >equivalent applicable work experience.
> >
> >Please send resume to :
> >
> > Alan Bowden
> >Great-West Life & Annuity Insurance Company
> > 8515 E. Orchard Rd., MS-5T2
> > Englewood, CO 80111
> > FAX: (303) 737-4850
> > EMAIL: alan.bowden_at_gwl.com
> >
> >
> >--
> >Author: Donita Hilfinger
> > INET: dohi_at_gwl.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
Received on Wed May 17 2000 - 21:14:11 CDT
