Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: logon trigger cannot prevent DBA account from logging in databa se

Re: logon trigger cannot prevent DBA account from logging in databa se

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 4 Apr 2006 17:42:22 +0100
Message-ID: <be592d550604040942k6ef924d3v4cc418dec441d191@mail.gmail.com>


you cant stop dba accounts from logging into the database. The reason being is that if you wrote a login trigger that didnt work then no-one could ever log into change it

Revoke dba from the user and grant him the priveleges he needs

On 04/04/06, TU Lijie <Lijie.Tu_at_comaupico.com> wrote:
>
> Hi all,
>
> I want to prevent certain OS users from logging in database using certain
> DB accounts (say: ORAUSR1). The following code works only if ORAUSR1 is NOT
> a DBA account. Can anybody please help?
>
> We have to grant the DBA role to the schema owner of our ERP system , but
> the password for this account is well-known and changing it is not advisable
> as many applications are using this account with hard-code the password.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 04 2006 - 11:42:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US