Granting Roles Using NT?

From: Eric Mortensen <emortens_at_harris.com>
Date: Mon, 07 Dec 1998 11:06:18 -0500
Message-ID: <366BFCF7.85F1FB45@harris.com>

I have been trying to grant roles using NT using the following steps:

On the server:

    Set OS_ROLES = TRUE
    In sqlnet.ora set SQLNET.AUTHENTICATION_SERVICES=(NTS)     create role comm identified externally;     grant resource to comm;
    grant connect to comm;
    shutdown and restart database

I then created NT local group name ORA_DEV_COMM Then added a user to that group.

I then login as that user and ran sqlplus /@dev

I get the folling error

ORA-01045: user BSMITH lacks CREATE SESSION privilege; logon denied

I am already using NT user authentication which works.

Any help would be greatly appreciated.

Eric Mortensen
emortens_at_harris.com Received on Mon Dec 07 1998 - 10:06:18 CST