Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
applications:custom_tableauth [2018/02/07 08:09] admin |
applications:custom_tableauth [2020/07/08 13:16] (current) cduncan articles |
||
|---|---|---|---|
| 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: | ||
| Line 16: | Line 16: | ||
| If you want to change the names without changing the source code, it's very easy to map the expected names to your own names. It's also possible to define synonyms in your database, if supported. | If you want to change the names without changing the source code, it's very easy to map the expected names to your own names. It's also possible to define synonyms in your database, if supported. | ||
| - | Simply add following to your config.xml: | + | Simply add the following to your config.xml: |
| <file xml> | <file xml> | ||
| Line 35: | Line 35: | ||
| <**origtablename**>//newtablename//</**origtablename**> | <**origtablename**>//newtablename//</**origtablename**> | ||
| - | It's also possible to change the column names of standard tables and views. Simply add following to your config.xml: | + | It's also possible to change the column names of standard tables and views. Simply add the following to your config.xml: |
| <file xml> | <file xml> | ||
| 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 the 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// | ||