Hi All,


I am wondering what other method people use for oracle
login-authentication.

1) sqlplus login-name/password

2) use OS authentication method (I used it before, it is fine.)

But is there any other method in 10g??


Thanks,


Dominica

"dominica@gmail.com" <dominica@gmail.com> wrote in
news:1121121681.364879.93150@g49g2000cwa.googlegro ups.com:

> Hi All,
>
>
> I am wondering what other method people use for oracle
> login-authentication.
>
> 1) sqlplus login-name/password
>
> 2) use OS authentication method (I used it before, it is fine.)
>
> But is there any other method in 10g??
>
>
> Thanks,
>
>
> Dominica
>
>

LDAP

In article <1121121681.364879.93150@g49g2000cwa.googlegroups. com>,
dominica@gmail.com says...
>
>Hi All,
>
>
>I am wondering what other method people use for oracle
>login-authentication.
>
>1) sqlplus login-name/password
>
>2) use OS authentication method (I used it before, it is fine.)
>
>But is there any other method in 10g??
>
>
>Thanks,
>
>
>Dominica
>
Oracle Advanced Security offers quite a few, including Kerberos. The
administrator's guide lists them.

Rick


--
Rick Wessman
Oracle Corporation
The opinions expressed above are mine and do not necessarily reflect
those of Oracle Corporation.

dominica@gmail.com wrote:
> Hi All,
>
>
> I am wondering what other method people use for oracle
> login-authentication.
>
> 1) sqlplus login-name/password
>
> 2) use OS authentication method (I used it before, it is fine.)
>
> But is there any other method in 10g??
>
>
> Thanks,
>
>
> Dominica

Depends on how much security you need and can afford. Userid/password,
either in Oracle or the operating system is very little security indeed.

Other options to explore:
Logon Triggers
FGAC
LDAP
Label Security
SQLNET.ORA ... invited/excluded nodes parameters
Oblix (now part of Oracle and providing the Identity Management piece)
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

On Sat, 16 Jul 2005 10:55:28 -0700, DA Morgan <damorgan@psoug.org>
wrote:

>Depends on how much security you need and can afford. Userid/password,
>either in Oracle or the operating system is very little security indeed.

Most vendors I work with don't password protect their application at
all, and usually expressly forbid to change that situation.


--
Sybrand Bakker, Senior Oracle DBA

Sybrand Bakker wrote:
> On Sat, 16 Jul 2005 10:55:28 -0700, DA Morgan <damorgan@psoug.org>
> wrote:
>
>
>>Depends on how much security you need and can afford. Userid/password,
>>either in Oracle or the operating system is very little security indeed.
>
>
> Most vendors I work with don't password protect their application at
> all, and usually expressly forbid to change that situation.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

You are correct. Here, due to changes in the law, some of those vendors
are discovering the need to change some of their policies.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)