How to set diffrent role for the user.

Question

0.00/5 (No votes)

See more:

Sir,
In my project, i have a page where i can add user & the data is save in a database & data fields are

Emp_id, Employee_code, First_name,Last_name, Gender, User_name, Password, ConformPass, mailid, Role,

Now, I want to set different role for every user(ex. admin, user and staff), so give me how to set the role for different users and please give me the query for that also, if you having it.

please help me ..i am new in asp.net

Posted 12-Apr-13 0:28am

prodipjsr

Add a Solution

Comments

prodipjsr 13-Apr-13 2:41am

Dear Sir's,
Still i am waiting for ur ans..if u hv any example with code please send me @ prodipjsr@gmail.com...

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)

Member 2707515 · Answer 1 · 2013-04-12T00:45:00

Solution 1

create a table called UserTypes with following fields:

user_type_id, user_type, creation_date, updation_date, is_enable

e.g 1, Admin, Date, Date, Y

and create also table called Roles in which different user to be assigne role:

role_id, role_name, creation_date, updation_date

e.g LOCALRI00000001, Admin, Date, Date

to update a role or user use updation query on submit button.
Actually, u have to create a MasterPage in that two link should be their
e.g. User, Roles, Employees.

Posted 12-Apr-13 0:45am

Member 2707515

Updated 12-Apr-13 0:46am

v2

Comments

prodipjsr 12-Apr-13 6:57am

ok i will create the table in my database, but how can set the role for a user!! say user the cant access all the page in my project. but admin can access all page in my project...please help me..if u have any code..

Member 2707515 12-Apr-13 7:25am

Follow Link:
http://www.flickr.com/photos/94899243@N04/

Member 2707515 12-Apr-13 7:08am

create a page Employee where u entered all employee detail their only a option for assing a role and which kind of users.

Member 2707515 12-Apr-13 7:09am

can u provide ur emailid i send u a image of ma project

prodipjsr 12-Apr-13 7:24am

i have create the page & i can insert user information with role into my table. now my question is how i can set access power for a user. Say i have 3 page in my web project. (i)create user, (ii)log in (iii)Transaction page. Now i have 3 user (a)admin (b)user (c) super user.
now how i set if the log in user is "user" then he cant access the page "(i)create user" or Transaction page. i hope u got my point..my mail id is..
prodipjsr@gmail.com

Member 2707515 12-Apr-13 7:57am

i understand ur query, u telling about rights.
different users have different rights.
for that u have to create a new table for rights.

Member 2707515 12-Apr-13 7:54am

actually i cant provide my project or coding its my live project for CMC so u can go for Solution2 member

prodipjsr 12-Apr-13 8:40am

Solution 2 is nothing but GAAN,,there is no code..there is no discussion how to check user with his role while login or go to others pagess

Pro Idiot · Answer 2 · 2013-04-12T01:26:00

As a beginner I would suggest you to go with ASP-NET-Roles-and-Membership.

Using asp.net's Role feature , you can minimize all the Database table and Stored procedure creation work . ASP.Net will create and manage all that for you .
You will be provided with a Admin UI , and you can well manage the login , registrations and the user page access roles .

Hope it helps

[ Happy Coding ]