How could we achieve role based authorization in windowsbased authentication with oracle

Question

0.00/5 (No votes)

See more:

Hi,
I need to implement the role based authorization, in my app which working on windows based authentication, and i am using the oracle database. i think membership work with forms authentication and with SQL server database. Here i am getting user names from domain and storing them in database, and checking the current system username with database name and then allow them to access the application,is there any sample to implement this scenario is appreciated.

Thanks

Posted 18-Aug-14 4:56am

V G S Naidu A

Updated 18-Aug-14 5:01am

v2

Add a Solution

Comments

PhilLenoir 18-Aug-14 11:17am

I believe that you can use Forms authentication and roles with an Oracle backend if you set up your connection and load the ASP.NET user/role structure correctly in the Oracle database., but if you have Windows authentication, why do you need it? - use Active Directory?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

-Dr_X- · Answer 1 · 2014-08-18T15:11:00

Solution 1

You should be able to capture the user's unique login SID and store it in Oracle. I do the same for SQL. However, my roles are custom application driven.

Posted 18-Aug-14 15:11pm

-Dr_X-