Managing Users

I need an application say where a hierarchy level is used in such a way to manage users. For example the parent can create a child node with a username and password. Then the tree goes down. But only each level above has access to the lower level.The tree now has three levels, then the tree goes down. I am a bit stumped on this one if anyone can help me I would apprecitate it .

Sincerely,
Matt Cupryk

Perhaps a commercial product like Authentix will work for you.

We actually have a very simple system for this.
Our table has a primary key that is a particular users ID.

There is also another field which we call manager ID. The manager ID has the User ID of the parent in the tree structure.

This way you can have a tree structure that goes as deep as the number of users you have!

eg.

CREATE TABLE #SampleUsersTbl
(UserID Int,
Otherfields VarChar(10),
ManagerID Int)

INSERT INTO #SampleUsersTbl VALUES (1,'',NULL)
INSERT INTO #SampleUsersTbl VALUES (2,'',1)
INSERT INTO #SampleUsersTbl VALUES (3,'',1)
INSERT INTO #SampleUsersTbl VALUES (4,'',3)

SELECT * FROM #SampleUsersTbl

DROP TABLE #SampleUsersTbl


Let me know if you understand how this works.
Joshua