This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information

--Use custom tables and views for authentication

Information about development with ProjX.

--Use custom tables and views for authentication

Postby Development@SIB » Fri Sep 22, 2017 2:10 pm



This article is outdated - please use our new system at

https://doc.sibvisions.com




If you use the standard DBSecurityManager, DBWorkScreenAccess or RoleBasedDBWorkScreenAccess you have to use the following table names:

AUTOLOGIN
USERS


and following view names:

V_ACCESSRULES
V_ROLESCREENS
V_USERROLES
V_USERSCREENS


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:

Syntax: [ Download ] [ Hide ]
<application>
  …

  <databaseobjects>
    <USERS>APP_USERS</USERS>
    <AUTOLOGIN>APP_AUTOLOGIN</AUTOLOGIN>
    …
  </databaseobjects>

</application>

The mapping syntax is:

<origtablename>newtablename</origtablename>

It's also possible to change the column names of standard tables and views. Simply add following to your config.xml:

Syntax: [ Download ] [ Hide ]
<databaseobjects>
  <USERS_CHANGE_PASSWORD>PWD_CHANGE_FLAG</USERS_CHANGE_PASSWORD>
</databaseobjects>

The syntax for column mapping is:

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

Syntax: [ Download ] [ Hide ]
<databaseobjects>
  <yes_value>1</yes_value>
</databaseobjects>

The value will be used in DBWorkScreenAccess and DBSecurityManager and following tables:

USERS
WORKSCREENS
User avatar
Development@SIB
 
Posts: 325
Joined: Mon Sep 28, 2009 1:54 pm

Return to Documentation