RE: Risk of knowing password hash value (Was: OEM permissions)
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Davey, Alan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Risk of knowing password hash value (Was: OEM permissions)
on SYS.V_$SGASTAT to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SHARED_SERVER to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$DATAFILE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$TABLESPACE to DBARTISAN_USER_ROLE; grant SELECT on SYS.V_$SESS_IO to DBARTISAN_USER_ROLE; grant SELECT on SYS.ALL_OBJECTS to DBARTISAN_USER_ROLE; grant SELECT on SYS.DBA_ROLLBACK_SEGS to DBARTISAN_USER_ROLE; grant SELECT on SYS.PRODUCT_COMPONENT_VERSION to DBARTISAN_USER_ROLE; grant SELECT on SYS.DBA_EXTENTS to DBARTISAN_USER_ROLE; grant DBARTISAN_USER_ROLE to USER_WE_DONT_LIKE; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Davey, Alan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author
RE: rebuilding indexes - sure to cause a ruckus
LOL, This made me think of the Simpson's Halloween episode where Monty Burns says, 'Smithers, this isn't rocket science, its brain surgery'. - Alan Davey Senior Analyst/Project Leader Oracle 9i OCA; 3/4 OCP w) 973.267.5990 x458 w) 212.295.3458 -Original Message- Sent: Wednesday, December 10, 2003 5:24 PM To: Multiple recipients of list ORACLE-L BTW, does anyone know what a rocket scientist refers to when they say Hey, this is all quite easy, it sure ain't ? ? Cheers ;) Richard Surely the Rocket Scientist version must be Hey, this is all quite easy, it sure ain't index rebuilding very evil grin Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This information in this e-mail is intended solely for the addressee and may contain information which is confidential or privileged. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy, retransmit, disseminate, or otherwise use the information. Also, please notify the sender that you have received this e-mail in error, and delete the copy you received. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Davey, Alan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Development vs. Production DBA
Title: RE: RE: Development vs. Production DBA Just don't grant execute. ;-) - Alan Davey Senior Analyst/Project Leader Oracle 9i OCA; 3/4 OCP w) 973.267.5990 x458 w) 212.295.3458 -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]Sent: Friday, November 21, 2003 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RE: Development vs. Production DBA But if you make them stored procedures, you might be giving up some vestige of control. CAN'T give up control... April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/ \ \ \ \ Few people really enjoy the simple pleasure of flying a kite Adam Wells age 11 -Original Message- From: Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Friday, November 21, 2003 8:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Development vs. Production DBA I don't normally like to get into these turf battles, but in this case I have to agree with Patrice. Most developers are looking strictly at their current project with no regard for anything they've done in the past or that others around them are doing. Also I find that a significant number of developers have an attitude that what they did in the past is sufficient for the future no new functionality in the database or elsewhere is needed. Believe it or not, we still have a test engineering programmer who uses Turbo Pascal. My greatest frustration is people who demand to write applications strictly in a client server mode. They see no benefit into encapsulating processes that are very database intensive into packages/procedures/functions. So instead of one round trip to the database they have to do 30 or 40 and wonder why they can't get sub second response from their application. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:14 AM To: Multiple recipients of list ORACLE-L not arrogance, experience. Granted, there are good developers out there. The tendency is to think only on a project by project basis in development because of the way developers sometimes get funding to sustain themselves. No offense was intended, it was a cautionary note nothing more. Patrice. -Original Message- Sent: Friday, November 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L the arrogance here is troubling. though there seems to be more incompetent developers who do not know the database I have worked with my share of incompetent DBAs. Havent used anything since versoin 5.0 and so on. Dont know anything at all about development. If a production DBA knows development, fine, their opinion is valuable, if they are an SA/DBA who cant code, cant design a system, then their opinion is not very valuable. Ive seen lots of silly roadmaps put up by production DBAs who dont know nearly as much as lead on. What large enterprise systems need is an experienced Systems Architect. Im not one of those, but they do wonders for projects and they should work with the DBA to decide the best way to implement something. From: "Boivin, Patrice J" [EMAIL PROTECTED] Date: 2003/11/21 Fri AM 07:12:13 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Development vs. Production DBA LOL -- developers deciding architecture design. Never really involved in implementing anything, all conceptual. I am what you call a "production DBA", my personal bias on this is that leaving architecture decisions to developers could be a mistake, if you think long term. The Production DBA should be involved, and should have the ability to veto any hair-brained scheme that is proposed. Patrice. -Original Message- Sent: Wednesday, November 19, 2003 12:20 PM To: Multiple recipients of list ORACLE-LI don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs.
