views:

526

answers:

2

I know that it is possible to use "OS authentication" to authenticate Windows users in Oracle database. The process is basically passing current Windows user id to Oracle for authentication.

The question is - is it possible to authenticate domain group in Oracle (as it is possible with SQL Server integrated security), so that there would be no need to create separate database user for each domain member?

A: 

I don't think this is possible, but I would love to be proven wrong.

Leigh Riffel
+1  A: 

It is possible.

Oracle has a whitepaper on this, and here's a tutorial,

Osama ALASSIRY