create roles in sql server

Hi,

In a simple way you can do like below.
Create the Role Master Table like below.

Role Master Table
Code	Description
1	Manager
2	Clerk
3	Director

with code as primary key.

Then create the User table like below.

User Table
ID	Name	Role
1	Name1	1
2	Name2	2
3	Name3	3

with Role column referencing the Code column in Role Master Table. and you can insert the data as the sample show in the example. this is a simplest way.

hope it helps.