Adding Privilage to Users

Question

0.00/5 (No votes)

See more:

Hi,
I have a Project in which Admins have to set privilage to some users, some privilages are listed below:

1.Actions like View/Edit/Add/Delete a Table Content
2.See Some Specific Menus

Also we need to check whether the user logged in is an Admin to give such privilages

So, PLease tell the DB structure to make this possible

Thanks in advance

Posted 9-Oct-13 19:51pm

id-athul

Add a Solution

Comments

Zafar Sultan 10-Oct-13 2:01am

This is such a complex functionality that I think you should not dwell into without the help of a responsible person present around you all the time. I am afraid this is not a correct place to ask such question. Nobody will design a DB structure for you. Neither is someone going to tell you what will be the DB structure as it is your project and you better know the relationships and all the necessary stuff. But yes, if you have done something and are stuck at some place we are happy to help you.

id-athul 10-Oct-13 3:03am

Okay, Got it

Thanks7872 10-Oct-13 2:09am

User reply button while making comment.

id-athul 10-Oct-13 3:03am

Thanks :)

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)

CodeBlack · Accepted Answer · 2013-10-10T01:48:00

If you have only four permissions Add/Edit/Delete/View then you can create table structure as mentioned below :

C#

User Table : 

Columns : 
	UserId (PK),
	UserName,
	FirstName,
	LastName,
	Password,
	IsAdmin (bool)


Modules Table : 

Columns :
	ModuleId (PK),
	Name,
	Description,
	

Priviledges Table :

Columns :
	PriviledgeId (PK),
	UserId (FK),
	ModuleId (FK),
	IsAdd (bool),
	IsView (bool),
	IsEdit (bool),
	IsDelete (bool)

Note : Above structure is only for the basic functionality. It can be enhanced more as per the requirement