A login system with three access levels

Question

0.00/5 (No votes)

See more:

, +

Hi ...

I am attempting to create a login page for Recruitment-system that has (3) access levels. If the access level is 1 (super Admin)they receive the Admin home page,if the level is 2(sub admin) they receive the (sub admin page) and If th access level is 3 (job seeker)they receive the (jobseeker home page)
also depending on access level of the user , some links will be hidden from the user if he is not have the appropriate access level to that page .

1 . what is the stored procedure to validates the username and password?

2-how to do this:
Login method on login button validates the username and password against the credentials in the database, when the user clicks the button and the try Login variable is returns true the access level is taken from the database where the username in the database matches the username text field. .

I'm a beginner in ASP.NET programming ~~plz~~ please help

Posted 19-Jun-12 5:16am

al-aml

Updated 19-Jun-12 5:34am

Shahin Khorshidnia

v3

Add a Solution

2 solutions

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)

Shahin Khorshidnia · Answer 1 · 2012-06-19T05:25:00

Hello

Look at these:

http://msdn.microsoft.com/en-us/library/dd338930.aspx[^]

http://blogs.msdn.com/b/lcris/archive/2005/06/15/sql-server-2005-procedure-signing-demo.aspx[^]

http://stackoverflow.com/questions/2190140/stored-procedure-in-sqlserver-user-login[^]

Overview of SQL Server Stored Procedure[^]

http://www.csharp-station.com/Tutorial/AdoDotNet/lesson07[^]

You can Redirect the user to his/her specific page after authentication.
Look at these:
ASP.NET authentication and authorization
ASP.NET Authentication

And I think you could find your answer by searching google.
Please look at this: Code Project Quick Answers FAQ

khangaldi · Answer 2 · 2012-06-19T07:08:00

Hi,This is a very simple solution:
first you need a store proc. to send username and password to data base,
Considering that you have a table like users.it must have a column like usertype!
something like this:

SQL

CREATE PROCEDURE [dbo].[Users_login]
	
	(
	 @Password nvarchar (16) ,
     @Username nvarchar (32)
	)
	
AS
	   SELECT Usertype,Password,Username FROM Users u  
    
    where Username=@Username and 
    u.Password=@Password

    ; 
	RETURN

Depending on the type of the user(returned by the first store proc) you can redirect each user to specific page or you can configure a single page to handle all users(not recommended) like:

ASP

<%= if(_isSuperAdmin) { %>
<div>
some data that only admin is allowed to see
</div>
<% } %>

A login system with three access levels

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0