RE: AIX 10g/11 and Oracle DBA logins

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 17 Jun 2008 09:03:14 -0400
Message-ID: <21469B88E0EA11498818517F210335310455AFD5@EPRI17P32001A.csfb.cs-group.com>


You can also use become (assuming it's available on AIX) to log in as oracle--it takes your password, not oracle's.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DIANNA GIBBS Sent: Monday, June 16, 2008 4:49 PM
To: oracle-l_at_freelists.org
Subject: AIX 10g/11 and Oracle DBA logins

We are moving all of our instances to AIX from Windows and VMS.

Since I have been the only DBA on the new AIX servers, I have been using the oracle OS user login. Now that we are moving into production, we have several DBAs and would like all of us to log in using our specific username
and su to oracle user or be able to do anything needed as if we were the oracle user. We are currently able to do this on Windows and VMS.

My AIX administrator tells me this cannot be done without everyone knowing the
oracle OS user password.

Is there any other way we can do this without everyone knowing the oracle OS
password? Or am I missing something and being too cautious? Can we not use sudo or something like this?
Or is SU and SUDO the same thing? I've googled and searched but have found nothing
regarding best practices or what other sites are doing. And if everyone has to know the Oracle
OS password, what keeps people from just logging in as Oracle?

Any direction or information appreciated. Thanks!
Dianna G.

--

http://www.freelists.org/webpage/oracle-l



Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html


--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 17 2008 - 08:03:14 CDT

Original text of this message