Help Granting Roles thru NT

From: Eric Mortensen <emortens_at_harris.com>
Date: Wed, 09 Dec 1998 15:17:25 -0500
Message-ID: <366EDAD4.10F35BBA@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 Wed Dec 09 1998 - 14:17:25 CST