Two User Levels granted for creating Users, Possible?

[ross_t]

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 ...

1. The User Level Drop-down is not shown to the Reseller User.

2. 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?

[arbei]

1. User Level table can only accessed by Administrator. If you want to expose it to other user levels, you can create a view.
2. You can use Parent User ID, see the tutorial about User ID Security in the help file.

[ross_t]

Your trick of creating View worked like a charm! Everything else worked smooth then.