Did you create a user OS$BSMITH in Oracle and give him the role comm?
Eric Mortensen wrote in message <366EDAD4.10F35BBA_at_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 Thu Dec 10 1998 - 08:15:23 CST
