Connecting Tech Pros Worldwide Forums | Help | Site Map

Problem with role management

Newbie
 
Join Date: Oct 2007
Posts: 4
#1: Dec 13 '07
Hello!

I have a serious problem. I'm working on a web application which uses an oracle database connection. I have three kind of users and I would like to restrict some users to access some pages on the server. I've overriden the RoleProvider class and implemented some functionality in it but the problem is that I can't make it work. It gives me an error message that it can't establish a connection with sql server (I don't even use it). So, my questions are the following:
- if I use an implemented RoleProvider class, will I be able to distinguish to users which belong to different roles and therefore deny access to some resources on the server?
- can I use the OracleClient class as usual to implement the specific methods needed?
- is any other way to implement this kind of functionality?
I've search the web for a day and I haven't find anything useful yet, I've found some documentation about how to implement this stuff using an ms sql server but what about an oracle database, I could ask.
So, any help is very appreciated! Thanks in advance!

Frinavale's Avatar
Site Moderator
 
Join Date: Oct 2006
Location: The Great White North
Posts: 5,131
#2: Jan 2 '08

re: Problem with role management


Quote:

Originally Posted by Zoliq

Hello!

I have a serious problem. I'm working on a web application which uses an oracle database connection. I have three kind of users and I would like to restrict some users to access some pages on the server. I've overriden the RoleProvider class and implemented some functionality in it but the problem is that I can't make it work. It gives me an error message that it can't establish a connection with sql server (I don't even use it). So, my questions are the following:
- if I use an implemented RoleProvider class, will I be able to distinguish to users which belong to different roles and therefore deny access to some resources on the server?
- can I use the OracleClient class as usual to implement the specific methods needed?
- is any other way to implement this kind of functionality?
I've search the web for a day and I haven't find anything useful yet, I've found some documentation about how to implement this stuff using an ms sql server but what about an oracle database, I could ask.
So, any help is very appreciated! Thanks in advance!

See this article on Role Management Providers for more information on configuring your project correctly to use your custom class.

See this Sample of Role-Provider Implementation for more information on creating a custom role provider.

There is no "simple" way to connect to an Oracle database serving as the data source for your role management. You're going to have to implement a custom role provider class...

-Frinny
Reply