Dynamic User level from Custom View

[anangjablai]

i have created 3 tables

1. kop_user
2. kop_userlevelpermissions
3. kop_userlevels

i have succeed make Dynamic User level with 3 tables above

i want to make Dynamic User level with 3 custom view

1. user
2. userlevelpermissions
3. userlevels

but i click Migrate button, there is an allert said "#42S02Table'_kop.userlevel' does not exist.

why it happened? Can i create Dynamic User level from Custom View?

[mobhar]

1. Have you changed those related settings from "Advanced Security" -> "User Levels" -> "Dynamic User Levels" ?
2. Have you changed the user table under "Security" -> "Use Existing Table"?

[Webmaster]

anangjablai wrote:
but i click Migrate button, there is an allert said "#42S02Table'_kop.userlevel' does not exist.

Migrating means inserting the Static user level settings to your specifed User Level tables. If the table does not exist (as your message said), it cannot insert. If the table is a Custom View involving more than one table, it cannot be inserted either. Avoid Custom View (see Using Custom View in the help file), avoid using Custom View as User Level tables.

[anangjablai]

mobhar wrote:

1. Have you changed those related settings from "Advanced Security" -> "User Levels" -> "Dynamic User Levels" ?
   yes, i have changed it
2. Have you changed the user table under "Security" -> "Use Existing Table"?
   yes, i have changed it

as webmaster said, now i don't use custom view for Dynamic User level

[mobhar]

Actually you may use a Database View (not Custom View) for your User Levels table, as long as it contains only one single table. This is useful if you want to disguise the expose the original table name.