Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Need Help with OS_ROLES feature in Oracle/NT Environment

Need Help with OS_ROLES feature in Oracle/NT Environment

From: Tapas Guha <tguha_at_sympatico.ca>
Date: Sun, 13 Jan 2002 21:55:59 -0800
Message-ID: <IFr08.3310$jt2.531623@news20.bellglobal.com>


Hello,

I am trying to use the Role granting from Os feature of Oracle in Windows/NT Environment.
I am having SID = TAPAS
I have created a Role called ORA_TAPAS_SYSTEM_ROLE_A and granted that role to system account in oracle.
I also created a group with the same name as the role and created a user called system and assigned the group.
Now when i logged in NT as system and then logged in Oracle and do a select from session_roles, i don't see any role assigned to system account. ?????
Please advise me what am i missing here ? Thanx for help in advance. Received on Sun Jan 13 2002 - 23:55:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US