Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: logon trigger cannot prevent DBA account from logging in databa se
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-lReceived on Tue Apr 04 2006 - 11:42:22 CDT