Trace: • Dropdown Menu Button
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision Last revision Both sides next revision | ||
applications:custom_tableauth [2018/02/07 08:09] admin created |
applications:custom_tableauth [2020/07/03 14:01] cduncan Edited for English grammar (capitalization, punctuation, correct verb conjugation) |
||
---|---|---|---|
Line 1: | Line 1: | ||
~~NOTRANS~~ | ~~NOTRANS~~ | ||
- | ~~Title: Use custom tables and views for authentication~~ | + | ~~Title: Use Custom Tables and Views for Authentication~~ |
If you use the standard DBSecurityManager, DBWorkScreenAccess or RoleBasedDBWorkScreenAccess you have to use the following table names: | If you use the standard DBSecurityManager, DBWorkScreenAccess or RoleBasedDBWorkScreenAccess you have to use the following table names: | ||
- | //AUTOLOGIN | + | //AUTOLOGIN \\ |
USERS// | USERS// | ||
and following view names: | and following view names: | ||
- | //V_ACCESSRULES | + | //V_ACCESSRULES \\ |
- | V_ROLESCREENS | + | V_ROLESCREENS \\ |
- | V_USERROLES | + | V_USERROLES \\ |
V_USERSCREENS// | V_USERSCREENS// | ||
Line 47: | Line 47: | ||
<**origtablename_origcolumnname**>//newcolumnname//</**origtablename_origcolumnname**> | <**origtablename_origcolumnname**>//newcolumnname//</**origtablename_origcolumnname**> | ||
- | A hidden feature is the support for changing the YES value. The standard value for YES is Y. If you want another value e.g. 1, simply add following to your config.xml: | + | A hidden feature is the support for changing the YES value. The standard value for YES is Y. If you want another value, e.g., 1, simply add following to your config.xml: |
<file xml> | <file xml> | ||
Line 57: | Line 57: | ||
The value will be used in DBWorkScreenAccess and DBSecurityManager and following tables: | The value will be used in DBWorkScreenAccess and DBSecurityManager and following tables: | ||
- | //USERS | + | //USERS \\ |
WORKSCREENS// | WORKSCREENS// | ||