SQL Query web.config file

williamroyal

New Member
I know how to set permissions for certain pages using the built in feature ASP.net has for creating users and setting authorisation in the web.config file. The problem I am having at the moment is that I have been requested to use an MS Access database to store users and user roles and I am not sure how to go about finding out how to set this in the web.config file. Is there away of querying the database in the web.config file to find out users for a specific role? If so how would I go about doing it? The code below is what I would've written if I had've used the ASP.NET Configuration builder tool.\[code\] <location path="admin.aspx"> <system.web> <authorization> <allow roles="Admin"/> <deny users="*"/> </authorization> </system.web></location>\[/code\]
 
Back
Top