Re: OSLEVEL AUTHENTICATION

There is OS authentication (through the password file mechanism and
membership of the unix dba group) and OS authentication (through the
dictionary and the OS).
The Oracle account, being a member of the dba group, always logs in
using the former mechanism.
Consequently, setting up an OPS$ORACLE account is redundant, and
turning it into a normal account doesn't work, the Oracle user will
still be able to use connect /
Also, one should lock the Oracle account from the O/S level and make
sure you can only su to it.

--
Sybrand Bakker
Senior Oracle DBA

.

Relevant Pages

  • Re: Oracle membership ?
    ... "We created a custom membership provider implementation for Oracle. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ORA-01031: insufficient privileges
    ... the oracle account is not a member of dba group.? ... Since the 'oracle' account is not a member of the 'dba' group you can't ...
    (comp.databases.oracle.server)
  • Re: file permission problem - 10g client on solaris
    ... to su to oracle poses a security risk. ... unavoidable (one reason for that is that no one works 7 x 24). ... reason for this is the oracle account is, ... I agree that multiple administrators are the rule not the exception. ...
    (comp.databases.oracle.server)
  • Re: Help: Lost sys/system password
    ... as long as I sudo to oracle user. ... likely not in the dba group, ... By trying to connect using the username (sys) instead of using O/S ...
    (comp.databases.oracle.server)
  • Re: SQL Server Replication Problem
    ... When you enable the odbc oracle data source as a subscriber there is a ... prompt for the oracle account and password, ... Looking for a book on SQL Server replication? ... > I have set up on ODBC to access an oracle database. ...
    (microsoft.public.sqlserver.replication)
Loading