Database Administration (MOSC)

MOSC Banner

Oracle integration to MS Active directory /create roles n assign to AD

I am working on project to integrate our Oracle database to MS active directory.

have done the following steps and I can connect to the database using user "EXTERNAL" and it works great.

Linux side: created AD account, defined Kerberos service name in Linux Kerberos host, created keytab file, updated the server's sqlnet.ora file

Client side: updated the sqlnet.ora file with krb5.conf, etc.

DDL for my user account:

CREATE USER pwkrpaud IDENTIFIED EXTERNALLY AS 'pwkrpaud@u.phxhealth.com';

GRANT DBA TO pwkrpaud;

GRANT CREATE SESSION TO pwkrpaud;

Question: 1. How do I map database schemas and roles to active directory groups and Oracle users?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center