In my current application, I have three User Levels... Admin, Reseller and User. In "Users" table, every entry has "owner" field which is automatically set to CurrentUserID().
Admin can create Reseller and User
Reseller can create User
User cannot create any user under him.
I've setup Static User Levels (dynamic are of no use here).
The Admin by default can create Users without any problems.
Since I've given Reseller User Level Add/Edit/Delete/List/View/Search access to Users table, Reseller can also create new Users; but ...
The User Level Drop-down is not shown to the Reseller User.
I want Reseller User to be able to see all the Users under him. Although there are entries in Users table with "owner" = Currently Logged in Reseller User's User ID, the "Users" table shows only Reseller User's own entry in the table. It does not list other entries.
How to solve this issue?