Windows Oracle Data Access Components (MOSC)

MOSC Banner

Question - Migrating Classic ASP to ASP.Net - Calling procedures to set USER_CONTEXT and assign ROLE

edited Jan 18, 2011 9:50PM in Windows Oracle Data Access Components (MOSC) 1 commentAnswered
Can anyone advise? I have a question – Migrating Classic ASP to ASP.Net – Calling procedures to set USER_CONTEXT and assign Secure Application ROLES before select, insert, update and delete
I hope that I have posted this question to the correct forum

Oracle Server Version: 10.2.0.3.0
Oracle Client Version 11.2..0.1.0
ODAC Version 11.2.0.1.1

In our old classic ASP code (using 0040) we had implemented shared ASP include files that contained sub routines to set client identity and assign secure application roles.
For example;
Function OraSetClientIdent
        Call OraConnect2SessionVars
        Dim mySQL_ClientIdent
mySQL_ClientIdent = "Begin DBMS_SESSION.SET_IDENTIFIER('" & Request.ServerVariables("LOGON_USER") & "'); End;"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center