Re: Help Granting Roles thru NT

Eric,

is your INSTANCE/SID = DEV? If YES then you only need to add "_D" to enable the role by default, like this
ORA_DEV_COMM_D Then it will work...

/Lars Bo Vanting
COREBIT TPI AG, Switzerland

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 Fri Dec 11 1998 - 04:32:59 CST